Jon Gallant

New SQL Server Date DataTypes: Date, Time, DateTime2 & DateTimeOffset

1 min read
sql

Great video on the new Date DataTypes in in Sql

  • [T-SQL Enhancements and Date/Time ](http://download.microsoft.com/download/8/5/1/851B0968-0BE0-417E-9DA9-B3A2A6E47A67/NewDateTime.wmv)

    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

Share:
Share on X