RE: Urgent : Problems with JDBC Date formats...

[Shah, Chintan V (Chintan)]

ya, I know the Escape sequence...but it doesn't work in case of
Ms-Access....gives error..
"Malformed GUID. in query expression '(datefield = {d 'yyyy-mm-dd'})'. Works
with SQL Server.

So, what to do in that case ??

Moreover, as Dmitri suggested...using "TO_DATE" function...which doesn't
work in Ms-Access/SQL Server Query... is it a function of Java ?? If, then
of which class ?

thanks and regards,
Chintan


-----Original Message-----
From: Ralph Einfeldt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 12:26 PM
To: [EMAIL PROTECTED]
Subject: AW: Urgent : Problems with JDBC Date formats...


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/>