Current timestamp parsing is quite complex and buggy
in my opinion, i.e. '2000-09-22 13:21:39+02' works (inserted
with now() function) but inserting '2000-09-22 13:21:39.11+02'::timestamp
(important is '.11+02') does not work (as I know). The problem
exists because postgresql _does_not_ show timestamp in unambiguous way.
After applying attached patch, JDBC sets datestyle to SQL and
uses 'MM/dd/yyyy HH:mm:ss.SS zzzz' format to parse a timestamp.
However the question remains. What should be fixed? JDBC or postgresql?
pgsql-patches by date
|Next:||From: Karel Zak||Date: 2000-11-23 11:44:21|
|Subject: 7.1: to_char(): Y,YY,YYY,YYYY fix|
|Previous:||From: Peter Mount||Date: 2000-11-20 08:12:23|
|Subject: RE: [JDBC] string conversion patch|