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