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

[venussof...@gmail.com [firebird-support]]

Hi all
 
 I have the following in my SELECT statement
 
COALESCE(CAST(tPB.dBillDt AS TIMESTAMP), '') AS tDocDt
 
 The COALESCE() converts the CAST()ed TIMESTAMP to ANSI standard 2014-05-03 
00:00:00.0000
 
 
 
CAST(COALESCE(tPB.dBillDt, '') AS TIMESTAMP) AS tDocDt
 
 The CAST() converts the COALESCE()ed TIMESTAMP to my regional and expected 
format 03.05.2014, 00:00:00.0000
 
 
 Is this an expected behavior?  Please advise.
 
 Thanks and regards
 Bhavbhuti