Subject Re: [ib-support] Jaybird JAVA date conversion problem
Author Rick Fincher
Hi Claus,

Be sure you have at least the RC2 version of JayBird, there were some date
conversion problems in some earlier versions.

Rick


----- Original Message -----

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