Subject | Jaybird JAVA date conversion problem |
---|---|
Author | Claus Heeg |
Post date | 2003-01-10T11:12:09Z |
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.java:136)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:328)
at
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.java:136)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:328)
at