Data Type | Format | Example |
ANSIDATE | yyyy-mm-dd | 2007-02-28 |
TIME WITH TIME ZONE | hh:mm:ss.ffff... [+|-]th:tm | 12:45:12.23456 -05:00 |
TIME or TIME WITHOUT TIME ZONE | hh:mm:ss.ffff... | 12:45:12.23456 |
TIME WITH LOCAL TIME ZONE | hh:mm:ss.ffff... | 12:45:12.23456 |
TIMESTAMP WITH TIME ZONE | yyyy-mm-dd hh:nn:ss.ffff... [+|-]th:tm | 2007-02-28 12:45:12.23456 -05:00 |
TIMESTAMP or TIMESTAMP WITHOUT TIME ZONE | yyyy-mm-dd hh:nn:ss.ffff... | 2007-02-28 12:45:12.23456 |
TIMESTAMP WITH LOCAL TIME ZONE | yyyy-mm-dd hh:nn:ss.ffff... | 2007-02-28 12:45:12.23456 |
INTERVAL YEAR TO MONTH | [+|-]years-mm | 55-4 |
INTERVAL DAY TO SECOND | [+|-]days hh:nn:ss.ffff... | -18 12:02:23.12345 |