15 August 2008
New SQL Server Date DataTypes: Date, Time, DateTime2 & DateTimeOffset
Great video on the new Date DataTypes in in Sql
SQL Server 2008 introduces new date and time data types: DATE – a date only type; TIME – a time only type; DATETIMEOFFSET – a timezone-aware datetime type; DATETIME2 – a datetime type w/ 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.
Date just stores the Date
Time just stores Time
DateTime2 stores extended dates "0001" to "9999"
DateTimeOffset supports TimeZoneOffset
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
Comment Policy: No HTML allowed. URIs and line breaks are converted automatically. Your e–mail address will not show up on any public page.
