DATE Archives - SQLServerGeeks

Don’t use ISDATE() function to check valid Date

October 11, 2016November 10, 2016 - by Sandip Pani - Leave a Comment

I got the below email from one of my teammate on ISDATE() function. Thanks to him for asking me the question. I do not have any idea on this behaviour of …

SQL Server / SQL Server Accidental DBA Series

Function to get date from datetime in SQL Server

December 7, 2014December 20, 2019 - by SQL Geek - Leave a Comment

Hi, Many a times need arises to get only date part from Datetime datatype/column/value. This blogs lists functions to get date from datetime in SQL Server. — SQL Server 2008 onwards …