DB2 Coalesce

DB2 COALESCE is used when we want to have some default value or some value to be populated if there is no value available.

For more information on DB2 COALESCE,read here on DB2 COALESCE function explanation and example

DB2 CASE statement

DB2 CASE statement is used if we want to assign some name based on possible values.
For more information on DB2 CASE statement,read on
DB2 CASE statement explanation and example

DB2 DATE Functions

There are many functions available in DB2 to work with DATEs.
For information on DB2 DATE functions ,please read here
DB2 DATE Functions

For information on DB2 Functions on TIME STAMP and Arithmetic operations,read here on
DB2 DATE Functions related to TIMESTAMP and Arithmetic operations