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