/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

0 vote347 views1 answer
Check user sql password from command line
SQL
0 vote316 views4 answers
Sql limit 1 offset 1
SQL
0 vote311 views1 answer
Remove default constraint sql server
SQL
0 vote334 views1 answer
How to get specific salary in sql
SQL
0 vote270 views2 answers
Jupyter notebook connect to database
SQL
0 vote340 views1 answer
Sql change primary key to composite key
SQL
0 vote314 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote318 views2 answers
How to update the multiple rows in sql
SQL
2 votes333 views1 answer
Column names in oracle sql
SQL
4 votes332 views1 answer
Oracle error line
SQL