Wrong date format
Slim

-----Original Message-----
From: Claus Heeg [mailto:heeg.c@...]
Sent: 10 January 2003 11:12
To: ib-support@yahoogroups.com
Subject: [ib-support] Jaybird JAVA date conversion problem


Dear Guys
I have problems to work with data in Jaybird- JDBC !
Fiebird and WebObjects and Jaybird 1.3.1

How to work something like that:

select * from table1 where my_date <> "17.11.1858" (or null or a
special date my birthday "09.04.1961" or other date)
the same here "... where my_date <> '1858-11-17 00:00:00 +0000' ...


the driver raises an error :
conversion error from string "1858-11-17 00:00:00 +0000"
Next exception:SQL State:null -- error code: 335544334 -- msg: GDS
Exception.
at
com.webobjects.jdbcadaptor.JDBCContext._jdbcErrorWithChannel(JDBCContext.jav
a:136)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:3
28)
at



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/