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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
