Geeks With Blogs
Sajeel Munir's Blog .NET Developer

DATE/TIME Data Types:

  • DATE – a date only type

  • TIME – a time only type

  • DATETIMEOFFSET – a time zone-aware date/time type

  • DATETIME2 – a date/time type with larger fractional seconds and year range than the existing DATETIME type

The new data types enable applications to have separate data and time types, while providing large data ranges or user-defined precision for time values.

Posted on Monday, December 3, 2007 5:36 PM | Back to top


Comments on this post: SQL Server 2008 introduces new date and time data types

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Sajeel Munir | Powered by: GeeksWithBlogs.net