0 - 4 of 4 tags for coalesce

Below is the statement that is a part of a stored procedure.
 
SET NOTNULLKEYLIST=' COALESCE('||OREPLACE(pkcollist,',',',''-1''),COALESCE(')||',''-1'') ';
 

Hi guys,
 
does anybody know, why coalesce around time interval calculation does not work ?
This works ok :
cast( (dr.CDS_RRRRMMDD_Trigger - P.party_indiv_birth_dt) as Interval YEAR) as Age
 
This doesn't :
coalesce( cast( (dr.CDS_RRRRMMDD_Trigger - P.party_indiv_birth_dt) as Interval YEAR) ,-1) as Age

Hi, i have a column defined:

END_TM TIMESTAMP(2)

On select I want to use CURRENT_TIMESTAMP(2) when END_TM is null

However, the following sql
 

select COALESCE(END_TM,current_timestamp(2))

throws error:

SELECT Failed. 3800:  Datatype Mismatch in THEN/ELSE expression.

Can coalesce and format function go together?

I want the output of a numeric field to be displayed in specific format ,and 0 when the value in the column is NULL.

So, I use

SELECT TRIM(COALESCE(Field,0) (FORMAT 'ZZZ,ZZZ,ZZ')) from Table;

where Filed is the column name and Table is table name.