It is common practice to extract only date part from datetime format, such as for a datetime of 2014-05-30 15:31:58.860, only 2014-05-30 is returned. Today we will show three main methods to choose from.
Method 1:
SELECT convert(DATE, GETDATE() )
Method 2:
SELECT CONVERT(VARCHAR(10),GETDATE(),126)
Method 3:
SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))
will mask the time part as 00:00:00.000. It sometimes is regarded as better performance here.
