Here’s some example to get the date part in sql with datetime data type :
1 | DATEADD(dd, 0, DATEDIFF(dd, 0, [yourdate])) |
or
1 | CONVERT(date, [yourdate]) |
SQL Query Get Date Only For The Date Part
Reply
Spearcross
All About Programming, Piece of My Mind, And Anything
