Re: bug?: java won't read timestamps
От | Dave Cramer |
---|---|
Тема | Re: bug?: java won't read timestamps |
Дата | |
Msg-id | 03cb01c0eeb6$db61c450$0302a8c0@INSPIRON обсуждение исходный текст |
Ответ на | bug?: java won't read timestamps (Holger Klawitter <holger@klawitter.de>) |
Список | pgsql-general |
Which version of the driver are you using? This has historically been a problem The relevant code is in java.sql Dave ----- Original Message ----- From: "Holger Klawitter" <holger@klawitter.de> To: <pgsql-general@postgreSQL.org> Sent: Wednesday, June 06, 2001 12:24 PM Subject: [GENERAL] bug?: java won't read timestamps > Hi there, > > I have a table containing "timestamp with time zone" and I observed > a strange problem: > > THE ENVIRONMENT: > Linux 2.4.0 > Postgres 7.1.2 > JDK 1.3.1 (same with JDK 1.3.0) > postgresql.jar from $PGHOME/share/java > > THE TABLE: > Table "hits" > Attribute | Type | Modifier > --------------+--------------------------+---------- > id | integer | > zeit | timestamp with time zone | > > THE PROGRAM: > > stmt = toDB.createStatement(); > ResultSet rs = stmt.executeQuery( "SELECT max(zeit) FROM hits" ); > rs.next(); > ts = rs.getTimestamp(1); // <-- breaks here > stmt.close(); > > THE ERROR: > > Bad Timestamp Format at 19 in 2001-03-05 17:17:13.24+01 > > The second fraction seems not to be supported by the jdbc timestamp > reader. BTW: there is no format specifier for them as well (at least > in the docs). > > I am helping myself by forcing a different output > to_char(max(zeit),"YYYY-MM-DD HH24:MI:SS+01") > Is there a better solution? > > (Is the relevant code in java.sql or is it in org.postgresql?) > > With kind regards / Mit freundlichem Gruß > Holger Klawitter > -- > Holger Klawitter > holger@klawitter.de http://www.klawitter.de > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
В списке pgsql-general по дате отправления: