Search code examples
javasqljdbcdb2coalesce

How to use COALESCE in DB2 while dealing with Date Field (YYYY-MM-DD)

I'm trying to query a date field Adm_DT which has null values like below :

select id, COALESCE(Stud.Adm_DT,'') from Student Stud

I'm getting an sql error

SQL Error [42818]: THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE. SQLCODE=-401, SQLSTATE=42818, DRIVER=4.9.78
Solution

  • Use COALESCE(TO_CHAR(ADM_DT, 'YYYY-MM-DD'), '').