/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

1 vote358 views1 answer
Window function mysql
SQL
0 vote354 views1 answer
How to select only id where is not in column mysql
SQL
0 vote361 views1 answer
Where field is null sql knex
SQL
8 votes351 views1 answer
Mac restore mysql database command line
SQL
3 votes411 views2 answers
See mysql users ubuntu
SQL
3 votes350 views2 answers
Brew start mysql
SQL
0 vote337 views1 answer
2020 new year
SQL
17 votes390 views2 answers
T_sql contains
SQL
0 vote334 views6 answers
Unique key in sql
SQL
4 votes352 views1 answer
Refresh postgres config
SQL