Re: TimestampTZ - Mailing list pgsql-general

From Paul Lambert
Subject Re: TimestampTZ
Date
Msg-id 46BFF236.6010407@autoledgers.com.au
Whole thread Raw
In response to Re: TimestampTZ  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List 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


pgsql-general by date:

Previous
From: Paul Lambert
Date:
Subject: Re: TimestampTZ
Next
From: "Pavel Stehule"
Date:
Subject: Re: Persistent connections in PHP