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