The proper jdbc way to do that, is to use the escape syntax:
for dates:
where datefield = {d 'yyyy-mm-dd'}
for timestamps:
where datefield = {ts 'yyyy-mm-dd hh:mm:ss[.f]'}
> -----Ursprüngliche Nachricht-----
> Von: Dmitri Colebatch [mailto:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 23. Oktober 2001 08:44
> An: Shah, Chintan V (Chintan)
> Cc: [EMAIL PROTECTED]
> Betreff: RE: Urgent : Problems with JDBC Date formats...
<snip/>
> "Select * From <table> WHERE (<dateField> = TO_DATE('2001/01/01',
> 'yyyy/mm/dd'))"
<snip/>
