11:11 AM
To: '[EMAIL PROTECTED]'
Subject: Re: Urgent : Problems with JDBC Date formats...
I cant guarentee that this will work with Access and SQL server, but the
proper way to do what you're trying to do is use a PreparedStatement with
setDate(2, new Date(2001, 1, 1)).
hth
dim
. 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',
'/mm/dd'))
snip/
:[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',
'/mm/dd'))
snip/
At 09:11 AM 23/10/01, you wrote:
ya, I know the Escape sequence...but it doesn't work in case of
Ms-Accessgives error..
Malformed GUID. in query expression '(datefield = {d '-mm-dd'})'. Works
with SQL Server.
So, what to do in that case ??
Moreover, as Dmitri suggested...using TO_DATE
Hi !
Standart JDBC Date (java.sql.Date) format : yyy-mm-dd.
- Original Message -
From: Dmitri Colebatch [EMAIL PROTECTED]
To: Shah, Chintan V (Chintan) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 9:43 AM
Subject: RE: Urgent : Problems with JDBC Date formats
: [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 9:43 AM
Subject: RE: Urgent : Problems with JDBC Date formats...
In that case perhaps you could try using the SQL TO_DATE function. I'm
not sure what the proper syntax for this is, but in Oracle you could use
something like:
Select * From table
I cant guarentee that this will work with Access and SQL server, but the
proper way to do what you're trying to do is use a PreparedStatement with
setDate(2, new Date(2001, 1, 1)).
hth
dim
On Tue, 23 Oct 2001, Shah, Chintan V (Chintan) wrote:
Hi all,
This is a very off-topic post (as