/SQL/How to return only the Date from a SQL Server DateTime datatype

How to return only the Date from a SQL Server DateTime datatype

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date))
for example

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
gives me

2008-09-22 00:00:00.000
Pros:

No varchar<->datetime conversions required
No need to think about locale

Source: stackoverflow.com

Similar codes

25 votes293 views5 answers
Date in mysql
SQL
0 vote324 views2 answers
Sql unique
SQL
0 vote287 views1 answer
Setval in postgres
SQL
0 vote269 views2 answers
Sql regex vowel
SQL
0 vote293 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
8 votes286 views1 answer
Today minus 15 days postgresql
SQL
0 vote285 views1 answer
Mariadb select limit offset
SQL
4 votes275 views2 answers
Bulk kill mysql processlist
SQL
0 vote275 views1 answer
Add column in sql server ubuntu
SQL
0 vote288 views1 answer
Close sql query vb.net
SQL