Re: [BUGS] BUG #1523: precision column value returned from

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