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