SQL convert DateTime to Date (SQL server 2005)

Question

I want to convert this: 2014-07-15 15:01:16.880

To: 2014-07-15

Or to: 2014-07-15 00:00:00:000

What is the best way to do this?

By the way, My database is inside a Microsoft SQL 2005 Server

Thanks in advance

Date is not a valid type in SQL server 2005 (Msg 243, Level 16, State 1, Line 1 Type date is not a defined system type.) — , Jul 15 '14 at 13:07
Or use `select substring('2014-07-15 15:01:16.880', 1, 10)` :) — juergen d, Jul 15 '14 at 13:13

score 2 · Accepted Answer · answered Jul 15 '14 at 13:12

2

There is no Date datatype in SQL Server 2005, it was added in SQL Server 2008.

To go with your second alternative, you can truncate the datetime to midnight on the same day:

SELECT DATEADD(DAY, DATEDIFF(DAY,0, YourDateColumn), 0)
FROM   YourTable

answered Jul 15 '14 at 13:12

Bridge

Matas Vaitkevicius · Answer 2 · 2014-07-15T13:14:22.257

0

SELECT CONVERT('2014-07-15 15:01:16.880', GETDATE(), 112)

edited Jul 15 '14 at 13:14

answered Jul 15 '14 at 13:08

This is not what was asked. The question is how to get the date only, without the time – dotnetom Jul 15 '14 at 13:12

2 Answers2