SQL Query to get DATE interval from SYSDUMMY1

The answer is –

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

More: DB2 DATE and TIMESTAMP examples

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.