| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Naz Gassiep <naz(at)mira(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: TimestampTZ |
| Date: | 2007-08-13 05:06:06 |
| Message-ID: | 62BE0117-9D60-4434-A3E7-C598448A3823@seespotcode.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2007-08-13 05:15:10 | Re: TimestampTZ |
| Previous Message | Naz Gassiep | 2007-08-13 04:47:06 | TimestampTZ |