Data and Time Data Types


Data Type           Storage Size        Description             Range
 timestamp          8 Bytes             Date and Time           4713 BC to 294276 AD
 date               4 Bytes             Date (no time)          4713 BC to 5874897 AD
 time               8 Bytes             Time (no date)          00:00:00 to 24:00:00
 interval           16 Bytes            Time interval           +- 178,000,000 Years