sql server programming: date time transformation -- sql server programming

RE: date time transformation

Mark Williams
2/7/2006 12:35:27 PM

SELECT CAST(DATEADD(dd, DATEDIFF(dd,0,datetime_column),0) AS smalldatetime)

--

[quoted text, click to view]

Re: date time transformation

Patrik
2/7/2006 2:17:21 PM

Another trick could be:

declare @date datetime
set @date = '2006-01-31 11:34:30.997'
select cast(cast(@date as int) as smalldatetime)

Note that in a regular select you would only need to use the last line
and replace @date with your column name.

Re: date time transformation

Aaron Bertrand [SQL Server MVP]
2/7/2006 3:16:08 PM

SELECT CONVERT(SMALLDATETIME, CONVERT(CHAR(8), datetimecolumn, 112))

[quoted text, click to view]

date time transformation

GB
2/7/2006 8:09:49 PM

Hello:
My datetime column contains values like
this : 2006-01-31 11:34:30.997.
How can I transform this value to :
2006-01-31 00:00:00 ?

Thanks,
GB

Re: date time transformation

Uri Dimant
2/8/2006 12:00:00 AM

GB
One more
SELECT CAST(FLOOR(CAST(GETDATE()AS FLOAT))AS DATETIME)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.