Is the following scenario possible in DB2 SQL?

Question

I want to convert a decimal 20060901 to the Date 2006-09-01 (YYYY-MM-DD) and then subtract 2 days to get date : 2006-08-30.
In Oracle when I run the following Query it works:

SELECT TO_DATE('2006-09-01', 'YYYY-MM-DD') - 2
FROM DUAL
but I do not know how to do the same in DB2

Answer 1

What you are looking for is the Char function which allows you to format the date to ISO, USA, EUR, JIS, and LOCAL formats

The command that you want is
SELECT CHAR((DateColumn - 2 days), iso)
FROM etc...

The word DAYS following the 2 translates the 2 into a value that can be subtracted from a date. You can also have day, month, months, year and years