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/
. 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/
: Urgent : Problems with JDBC Date formats...
The proper jdbc way to do that, is to use the escape syntax:
for dates:
where datefield = {d '-mm-dd'}
for timestamps:
where datefield = {ts '-mm-dd hh:mm:ss[.f]'}
-Ursprüngliche Nachricht-
Von: Dmitri Colebatch [mailto
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
Hi all,
This is a very off-topic post (as perhaps it has nothing to do with tomcat),
but I hope people would like to guide me on this..
I'm using Tomcat 3.2, Apache 1.3.19, Jdk 1.3, Jdbc-Odbc Driver on Win NT
4.0. I want my application to work with both the databases..i.e. with
Ms-Access 2000
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