Re: [JDBC] Prepared statement performance...

Dimtry,



Dmitry Tkach wrote:

> Not realy... You should not be required to know about postgres date
> format, as long as it matches Timestamp.toString () output (and it
> currently does), and I
> see no reason why it would not (you just need to make sure that the
> client and the server are in the same locale, but that's a different
> discussion, because whatever
> JDBC does in setTimestamp () would locale-dependent anyway).

This certainly isn't true for all databases.  Oracle for example where
the database format for dates is DD-MON-YY which is very different from
the Timestamp.toString() method.  And actually the postgres format is
different and incompatible with javas format when you start having to
deal with timezone information.

thanks,
--Barry