Date,datetime,datetime2 Date and Time data type

The dates range from 0001-01-01 to 9999-12-31.
The time range is wide from 00:00:00 to 23:59:59.9999999.

-----------------DATE--Store only DatesSelect cast('2016-10-13 12:23:30'  asdate)--output Result: 2016-10-13----------------- TimeSelect cast('2016-10-13 12:23:30'  asTime )--Store time only--output Result: 12:23:30.0000000-----------------TIMESTAMP--Binary number of timestampsSelect cast('2016-10-13 12:23:30'  as timestamp)--output Result: 0x323031362d31302d-----------------DATETIME--Storage Standard TimeSelect cast('2016-10-13 12:23:30'  as DATETIME)--output Result: 2016-10-13 12:23:30.000-----------------DATETIME2Select cast('2016-10-13 12:23:30'  asDATETIME2)--output Result: 2016-10-13 12:23:30.0000000-----------------DATETIMEOFFSETSelect cast('2016-10-13 12:23:30'  asDATETIMEOFFSET)--output Result: 2016-10-13 12:23:30.0000000 +00:00

Date,datetime,datetime2 Date and Time data type