Subject Re: [firebird-support] NULL Date values
Author Nando Dessena

M> Perhaps you could use a COALESCE(MyColumn, DateToStr(MyColumn), '')
M> to work around the display problem?

I think it would have to be

case when mycolumn is null then '' else datetostr(mycolumn) end


P.S. I assume the library doesn't use UDF descriptors, in which case it
will be hard to have it recognize NULLs.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at