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]) |
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]) |