RE: [firebird-support] COALESCE() + CAST() converts timestamp format

[Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]]

By the way, Bhavbhuti,

CAST(COALESCE(tPB.dBillDt, '') AS TIMESTAMP) AS tDocDt

will fail if tPB.dBillDt is null since '' cannot be converted to a timestamp 
(it is neither a timestamp nor null).

Set