SQL Query to get DATE interval from SYSDUMMY1

Posted by

The answer is –

db2 >>
SELECT 
(current date) - date(2008-08-06) 
FROM sysibm.sysdummy1

More: DB2 DATE and TIMESTAMP examples