Data typeSizeRangesResolutionDescription
TIME [(p)]8 bytes00:00:00.000000 to 24:00:00.000000Between seconds and microsecondsTime of day
DATE8 bytes4713 BC to 5874897 ADdaysDate
TIMESTAMP [(p)]8 bytes4713 BC to 294276 ADBetween seconds and microsecondsDate and time

p is an optional precision value to specify the number of fractional digits retained in the seconds field. Range of p is from 0 to 6. Default is 6.

All these types do not include time zone information.

See relevant information on DATE/TIME formats in Date and Time Formatting Functions.