Understanding Date and Time Functions and Operations in SQL Server: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Understanding Date and Time Functions and Operations in SQL Server

page 7 of 8

by Abhishek Kumar Singh
Feedback

Average Rating:

Views (Total / Last 10 Days): 43493/ 156

Article Contents:

New date/time features in SQL Server 2008

· In SQL Server 2008 valid date range has be increased. It can from 0001-01-01 to 9999-01-01.

· SYSDATETIMEOFFSET function has been added to get the time zone offset with the date-time.

· In SQL Server 2008 the number of precision for second has been increased up to 7 which is only 3 in the SQL Server 2005 version.

· SWITCHOFFSET is used to set a new time zone.

· Also, SQL Server 2008 has added 4 new data types:

* DATE – a date only type
* TIME – a time only type
* DATETIMEOFFSET – a time zone aware datetime type
* DATETIME2 – a datetime type w/ larger fractional seconds and year range than the existing DATETIME type

So maybe in a few years, we will not need to worry so much about separating out dates and times.

« (Page 6)

View Entire Article

(Page 8) »

User Comments

Title: datetime in sqlserver
Name: murali
Date: 2010-11-11 12:52:06 AM
Comment:
How to alter the datetime to date conversion

Title: Great!!
Name: Shyam
Date: 2009-12-30 12:33:12 AM
Comment:
Thank you for your nice article.
it Gives me a better understanding to know time Manipulation Function!

Title: awesome
Name: mahesh
Date: 2009-05-29 4:15:11 PM
Comment:
great job it helped me a lot thank you very much!!!!!!

Title: Great!!!
Name: Gourik Kumar Bora
Date: 2009-03-31 3:21:57 AM
Comment:
Hi,
Thanks a lot. quite a helpful article..

Title: set datefirst inside function
Name: ll
Date: 2008-11-17 7:24:10 AM
Comment:
how to use set datefirst inside function

Title: Thanks.
Name: Abhishek (Author)
Date: 2008-11-13 8:05:34 AM
Comment:
Thanks to all of you for appreaciating my article.

Title: Thanks a Lot
Name: Krishna Prabhu
Date: 2008-11-13 4:43:50 AM
Comment:
Thanks a lot for giving this artical.It helped in completing project

Title: Thnx a Ton
Name: Neha Mishra
Date: 2008-11-12 2:15:52 AM
Comment:
Thnx a ton for such a detailed and informatic article. It helped in clearing almost all my doubts.

Title: Thank you
Name: Vishal s.surana
Date: 2008-11-11 7:44:52 AM
Comment:
Thank you for your nice article.It is very helpful to understand differnt behaviour of datetime datatype.