| Subject | RE: [firebird-support] COALESCE() + CAST() converts timestamp format |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2014-05-13T07:12:36Z |
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
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