Search Postgresql Archives

Re: Problems with timestamp with time zone and old dates?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <scrawford@xxxxxxxxxxxxxxxxxxxx> 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.

N.B the offset prior to November 18, 1883.

Cheers,
Steve



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux