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