THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

My datetime article updated for 2008

Actually, the article has been out for about a month now, but I first solicited feedback on errors and typo's and then I forgot to mention the update here...

Anyhow, the article now also covers 2008 and the new date, time, datetime2 and datetimeoffset types. There are some interesting aspects of the new types which sets them apart from the old types. As always, I'll be happy if you let me know about errors or typos.

http://www.karaszi.com/SQLServer/info_datetime.asp

Published Tuesday, September 23, 2008 5:10 PM by TiborKaraszi

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

tosc said:

THX for your wonderful update - Frank Kalis will make an updated translation of your great "white paper"

CU

tosc

September 29, 2008 12:00 PM
 

TiborKaraszi said:

Thanks Torsten! :-)

Yes, I e-mailed Frank a few days ago and I'm glad that he has the patience to translate it to German. "Translate-worthy" perhaps is a new term... :-)

September 29, 2008 12:14 PM
 

tosc said:

"Translate-worthy" that`s what I mean :-)

Once more thanks for your great work!

CU

tosc

September 29, 2008 12:36 PM
 

jgurgul said:

Hi,

I believe this is quicker for SQL2008 to remove time part.

Nice article by the way :)

Jon

--Type alternative

SET @t = GETDATE()  

SELECT  

CAST(CAST(date_time AS DATE) AS DATETIME)

,COUNT(*)  

FROM dbo.date_table  

GROUP BY CAST(CAST(date_time AS DATE) AS DATETIME)

OPTION (MAXDOP 1);  

SELECT DATEDIFF(ms, @t, GETDATE()) AS "Type alternative"

October 5, 2010 9:27 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement