Subject Re: [firebird-support] Re: NULL Date values
Author Paul Vinkenoog
In addition:

> Look at the declaration of the function DateToStr
> (...)
> If, on the other hand, it is passed by reference (pointer or
> cstring) or by descriptor, the function can tell NULLs from zeroes
> and should be improved.

If you should choose to go down this avenue I should add that

- with descriptors, UDFs can always handle NULLs

- with cstrings, even if the UDF can handle NULL input, the
Firebird engine will by default pass NULL arguments as empty strings,
*unless* you use Firebird 2 *and* the function is declared in a
special way to the database. Fot details, see
and more in particular

But it's probably quicker to follow Nando's advice and use a CASE
statement. Still it would be a good idea to report this undesired
behaviour to the rfunc team.