The SQL standard differentiates timestamps with time zone and without time zone literals by the presence of a "+" or "-" symbol and time zone offset after the time. Hence, according to the standard,
Without time-zone
'1999-01-08 04:05:06'
With time-zone
'1999-01-08 04:05:06 -8:00'
No comments:
Post a Comment