Subject | Re: [firebird-support] NULL Date values |
---|---|
Author | Nando Dessena |
Post date | 2007-09-10T16:23:53Z |
Martijn,
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
instead.
P.S. I assume the library doesn't use UDF descriptors, in which case it
will be hard to have it recognize NULLs.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
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
instead.
P.S. I assume the library doesn't use UDF descriptors, in which case it
will be hard to have it recognize NULLs.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================