At 12:42 PM 10/01/2003 +0100, you wrote:

>Claus,
>I know nothing about Jaybird, but a bit about SQL:
>
>SELECT * FROM TABLE1
>WHERE MY_DATE IS NOT NULL AND NOT (MY_DATE = '09.04.1961')
>
>I have never seen <> in SQL and doubt it is allowed.

It's allowed!
This isn't: <> NULL

And these are definitely all illegal SQL expressions:

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

try:

select * from table1 where my_date <> CAST('17.11.1858' AS DATE);
(Note especially the SINGLE quotes on the date literal!!!)

... where my_date <> '1858-11-17 00:00:00 +0000' is absurd. How could that
possibly evaluate to any known type?

Perhaps you meant

... where my_date <> cast('1858-11-17 00:00:00.0000' as timestamp)

heLen