Thomas Lockhart writes:
> SQL9x "timestamp" has no notion of time zones. PostgreSQL "timestamp"
> does.
AFAICT, it does not. The value is stored in UTC (more or less) and is
converted to the local time zone for display. But a data type is defined
in terms of storage, not display. In fact, if you use a language binding
that converts PostgreSQL values directly to native data types, then the
time zone never appears.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter