This example assumes that the default format for DATE values is 'yy/mm/dd'. Consider the following statements:
SET TIME ZONE INTERVAL '01:00' HOUR TO MINUTE; SELECT CURRENT_DATE AT INTERVAL '09:00' HOUR TO MINUTE;
The preceding SELECT statement returns the current date based on the time zone displacement, INTERVAL '09:00' HOUR TO MINUTE. If the current timestamp at UTC is TIMESTAMP '2008-06-01 19:30:00.000000+00:00', the SELECT statement returns '08/06/02' as the date.
If the SELECT statement has no AT clause or has an AT LOCAL clause, the statement returns '08/06/01' as the current date based on the current session time and time zone displacement, INTERVAL '01:00' HOUR TO MINUTE.
The date returned is not adjusted to account for the start or end of daylight saving time.