DB2 : Select Yesterday Date

Current Date

SELECT DATE(CURRENT TIMESTAMP ) FROM SYSIBM.SYSDUMMY1

Yesterday Date 

SELECT DATE(CURRENT TIMESTAMP - 1 DAYS) FROM SYSIBM.SYSDUMMY1