On Tue, 23 Oct 2001, Shah, Chintan V (Chintan) wrote:

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

I wasn't aware of this, but looks to me to be exactly what you want... I
think the problem you have is the fact that you're trying to use access as
a database... 

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

TO_DATE is an oracle thing I think... but faik it might be part of SQL.... 

cheers
dim

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

Reply via email to