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