Datetime types
Datetime data types include DATE, TIME, TIMETZ, TIMESTAMP, and TIMESTAMPTZ.
Topics
Storage and ranges
| Name | Storage | Range | Resolution |
|---|---|---|---|
| DATE | 4 bytes | 4713 BC to 294276 AD | 1 day |
| TIME | 8 bytes | 00:00:00 to 24:00:00 | 1 microsecond |
| TIMETZ | 8 bytes | 00:00:00+1459 to 00:00:00+1459 | 1 microsecond |
| TIMESTAMP | 8 bytes | 4713 BC to 294276 AD | 1 microsecond |
| TIMESTAMPTZ | 8 bytes | 4713 BC to 294276 AD | 1 microsecond |
