Hello.
Thanks for the response.
The value being returned from PG, with the odd offset is expected?
Thanks again,
Michael.
On Tue, Aug 21, 2012 at 5:50 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 08/21/2012 02:29 PM, Michael Clark wrote:
>
>> Hello all,
>>
>> I have a weird situation I am trying to work through, and could use some
>> help if anyone can provide some.
>>
>> I have a table with a column to store timestamp with time zone, and when
>> I store an older take (before 1895 or so), the value I get back from PG
>> when doing a select seems odd and is causing my client some issues with the
>> format string.
>>
>> For example, if I insert like so:
>> INSERT INTO sometable (startdate) values ('1750-08-21 21:17:00+00:00');
>>
>> I get the following when I select:
>> SELECT startdate FROM sometable;
>> startdate
>> ------------------------------
>> 1750-08-21 15:59:28-05:17:32
>> (1 row)
>>
>>
>> It's the odd offset that is causing my client problems, and I was
>> wondering if this is expected?
>> (I am using PG9.1.3)
>>
>> This contrasts:
>> INSERT INTO sometable (startdate) values ('2012-08-21 21:17:00+00:00');
>>
>> I get the following when I select:
>> startdate
>> ------------------------
>> 2012-08-21 17:17:00-04
>> (1 row)
>>
>>
>> Can anyone shed some light on if this is expected, or if I am doing
>> something odd?
>>
>> Much appreciated!
>> Michael
>>
>> PostgreSQL derives its timezone rules from the Olson database:
> http://en.wikipedia.org/wiki/**Tz_database<http://en.wikipedia.org/wiki/Tz_database>
> .
>
> N.B the offset prior to November 18, 1883.
>
> Cheers,
> Steve
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
