/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

2 votes216 views1 answer
Sql skip the first row
SQL
0 vote200 views1 answer
Postgresql add not null and not empty constraint
SQL
9 votes233 views3 answers
Postgres make sql dump
SQL
0 vote192 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote209 views1 answer
How to input data as id in database sql c#
SQL
0 vote206 views1 answer
Sql server query database space available
SQL
0 vote207 views1 answer
Connect by query in oracle
SQL
1 vote214 views1 answer
Table infromation in sql server
SQL
0 vote213 views2 answers
How to install mssql on mac
SQL
5 votes218 views1 answer
How to get all dates in a month in oracle
SQL