Re: [GENERAL] postgres timestamp data errors

2012-11-30 Thread Kevin Grittner
maxxedev maxxedev wrote: > db=# show timezone; >  TimeZone > -- >  Eire > (1 row) > db=# insert into test_table values('1912-03-14 00:00:00.00 -0025'); > INSERT 0 1 > db=# select * from test_table; >  invoice_date > -- >  1912-03-13 23:59:39-00:25:21 > (1 r

[GENERAL] postgres timestamp data errors

2012-11-30 Thread maxxedev maxxedev
Hi, We have a problem with postgres handling of certain timestamps where the timestamps can go into postgres through jdbc interface but cannot be retrieved back. It appears to be partly postgres-jdbc and partly postgres server problem. Here is an example: db=# show timezone; TimeZone -