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.