Subject Re: [firebird-support] Datatypes are not comparable in expression COALESCE.
Author Dimitry Sibiryakov
28.02.2010 10:56, Marcin Bury wrote:
> I thought that it should work since 'data' type is some kind of
> 'numeric' type. But I was wrong - and got error as in subject.

Where did you pick up such strange idea? You can use expression
"date'2000-01-01'" or something like that to get valid date.