DATE | ✅ | | Date and time, 8 bytes storage, 4713 BC to 5874897 AD range, and resolution 1 second. |
INTERVAL DAY TO SECOND [(p)] | ✅ | | Period of time, 12 bytes storage, -178000000 years to 178000000 years range, and resolution 1 microsecond / 14 digits |
INTERVAL YEAR TO MONTH | ✅ | | Period of time, 12 bytes storage, -178000000 years to 178000000 years range, and resolution 1 microsecond / 14 digits. |
TIMESTAMP [(p)] | ✅ | | Date and time, 8 bytes storage, 4713 BC to 5874897 AD range, and resolution 1 microsecond. |
TIMESTAMP [(p)] WITH TIME ZONE | |