Hi I need to select previous day on db2 database to automate a process.
Select *
from table
where created_date > (SELECT date(days(current date) - 1)
FROM SYSIBM.SYSDUMMY1)
This qry bring previous day in format '3/9/2011 12:00:00 AM' but I need the result in 'YYYY-MM-DD-00.00.00.000000' format in order to read from db2 table.