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 | | | |
