| From: | Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: TimestampTZ |
| Date: | 2007-08-13 05:55:02 |
| Message-ID: | 46BFF236.6010407@autoledgers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Paul Lambert wrote:
> Refer to this paragraph: (8.5.1.2)
>
> For timestamp with time zone, the internally stored value is always in
> UTC (Universal Coordinated Time, traditionally known as Greenwich Mean
> Time, GMT). 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.
>
>
Chapter 8.5.1.3 that was actaully, my apologies.
--
Paul Lambert
Database Administrator
AutoLedgers
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2007-08-13 06:45:20 | Re: Persistent connections in PHP |
| Previous Message | Paul Lambert | 2007-08-13 05:50:22 | Re: TimestampTZ |