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