/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

3 votes142 views1 answer
Oracle user quota unlimited
SQL
4 votes984 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
12 votes150 views4 answers
How to take database dump in postgresql
SQL
0 vote153 views1 answer
Flask sqlalchemy remove duplicates
SQL
3 votes161 views1 answer
Select database in sql
SQL
0 vote145 views1 answer
Power query case when
SQL
28 votes114 views6 answers
Distinct sql
SQL
-1 vote163 views1 answer
Adding a new table psql
SQL
0 vote153 views1 answer
Oracle webcenter content search enginer
SQL
0 vote135 views1 answer
Mysql error 1452
SQL