Suppose you have a date time ‘2010-01-01 10:00:30’ or you even just use GETDATE() and you are only interested in the data element. In oracle you would use TRUNC. In MS SQL you can just CAST it as a DATE as below:

1
2
3
SELECT CAST(GETDATE() AS DATE)
;
GO