[JDBC] timestamp parsing - Mailing list pgsql-patches

From wrobell
Subject [JDBC] timestamp parsing
Date
Msg-id 20001120124301.E1889@pred.posexperts.com.pl
Whole thread Raw
List pgsql-patches
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?

  wrobell <wrobell@posexperts.com.pl>

Attachment

pgsql-patches by date:

Previous
From: Karel Zak
Date:
Subject: 7.1: to_char(): Y,YY,YYY,YYYY fix
Next
From: Peter Mount
Date:
Subject: RE: [JDBC] timestamp parsing