Re: [BUGS] BUG #1523: precision column value returned from - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: [BUGS] BUG #1523: precision column value returned from
Date
Msg-id 422F6641.6030806@opencloud.com
Whole thread Raw
In response to Re: [BUGS] BUG #1523: precision column value returned from  (Sergio Lob <Sergio_Lob@iwaysoftware.com>)
Responses Re: [BUGS] BUG #1523: precision column value returned from  (Sergio Lob <Sergio_Lob@iwaysoftware.com>)
List pgsql-jdbc
Sergio Lob wrote:

> What format does PostgreSQL return in getString() method for a timestamp column, for example? Seems like it should
returnsame as toString() method of a timestamp object as defined in java 2 api spec. 

It returns the string representation the backend gave it. This is true
for all types at the moment. For a timestamp with timezone value this is
generally going to be yyyy-mm-dd hh:mm:ss.nnnnnnzzz:

test=# select now();
               now
-------------------------------
  2005-03-10 10:08:11.707753+13
(1 row)

Does the JDBC spec say somewhere that we should return a different format?

-O

pgsql-jdbc by date:

Previous
From: Ryszard Lach
Date:
Subject: PostgreSQL 8.0 can't print duration in log when client uses 8.0 jdbc driver
Next
From: Oliver Jowett
Date:
Subject: Re: Crystal Reports: Connection rejected: FATAL: no PostgreSQL