How to Convert following date to YYYY-MM-DD

Question

I entered data into a database, but the date is off, it is showing to the seconds.

How can i do a select statement to get this:

2010-02-18 07:45:00

To This:

2010-02-18

I am not the computer guy here....Thanks!

Duplicate of this http://stackoverflow.com/questions/113045/how-to-return-the-date-part-only-from-a-sql-server-datetime-datatype — David Mårtensson, Feb 25 '11 at 20:20

score 3 · Accepted Answer · answered Feb 25 '11 at 20:21

3

SELECT Convert(varchar(10), DateColumn, 120) FROM TABLE

answered Feb 25 '11 at 20:21

amit_g

For more functionality on the style (format of the date) Microsoft has a helpful page : http://msdn.microsoft.com/en-us/library/ms187928.aspx – Jacob Saylor Feb 25 '11 at 20:50
@Bill - if it works perfectly you should mark this answer as the correct/accepted answer so @amit_g gets the credit for helping you. – AMadmanTriumphs Feb 25 '11 at 20:53
Check out http://stackoverflow.com/questions/113045/how-to-return-the-date-part-only-from-a-sql-server-datetime-datatype for tips on faster solutions performance wize. – David Mårtensson Feb 25 '11 at 21:11

score 1 · Answer 2 · answered Feb 25 '11 at 20:19

1

For any SQL Server version

select dateadd(d, datediff(d, 0, datecolumn), 0), ..
from ..

or for your 2008

select CAST(datecolumn as Date), ....
from ..

answered Feb 25 '11 at 20:19

RichardTheKiwi

score 0 · Answer 3 · answered Feb 25 '11 at 20:18

0

DATE('2010-02-18 07:45:00');

or variable in there

Or just change the column type definition from datetime to date

answered Feb 25 '11 at 20:18

rayman86

3 Answers3