Re: postgres timestamp data errors

maxxedev maxxedev wrote:

> db=# show timezone;
>  TimeZone
> ----------
>  Eire
> (1 row)

> db=# insert into test_table values('1912-03-14 00:00:00.000000 -0025');
> INSERT 0 1
> db=# select * from test_table;
>  invoice_date
> ------------------------------
>  1912-03-13 23:59:39-00:25:21
> (1 row)
>
>
> Note that inserted timestamp and stored timestamps are logically
> equivalent. However, why does SELECT show the timestamp in a timezone
> offset with minute precision?

Because in 1913, that was the offset between Dublin time and GMT.

http://www.velocityreviews.com/forums/t372817-timestamp-and-the-eire-timezone.html

-Kevin