Date Time Types

|Name | Storage Size | Description | Low Value | High Value | Resolution | | —– | ———–– | ————— | ———–– | ———– | ––––– | timestamp (without time zone) | 8 bytes | both date and time (no time zone) | 4713 BC | 294276 AD | 1 microsecond / 14 digits timestamp (with time zone) | 8 bytes | both date and time, with time zone | 4713 BC | 294276 AD | 1 microsecond / 14 digits date | 4 bytes | date (no time of day) | 4713 BC | 5874897 AD | 1 day time (without time zone) | 8 bytes | time of day (no date) | 00:00:00 | 24:00:00 | 1 microsecond / 14 digits time (with time zone) | 12 bytes | times of day only, with time zone | 00:00:00+1459 | 24:00:00-1459 | 1 microsecond / 14 digits interval | 16 bytes | time interval | -178000000 years | 178000000 years | 1 microsecond / 14 digits tsrange | | range of timestamp without time zone| tstzrange| | range of timestamp with time zone | daterange| | range of date |