Re: TimestampTZ

On Aug 12, 2007, at 23:47 , Naz Gassiep wrote:

> When entering data into a timestamptz field, if no timezone is
> added does it assume you've entered a UTC time, or the time at the
> timezone set in the session with SET TIMEZONE, or the local system
> time ?


As clearly stated in the documentation

http://www.postgresql.org/docs/8.2/interactive/datatype-
datetime.html#DATATYPE-TIMEZONES

> An input value that has an explicit time zone specified is
> converted to UTC using the appropriate offset for that time zone.
> If no time zone is stated in the input string, then it is assumed
> to be in the time zone indicated by the system's timezone
> parameter, and is converted to UTC using the offset for the
> timezone zone.


Michael Glaesemann
grzm seespotcode net