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