SQL Query to get DATE interval from SYSDUMMY1

I have shared a SQL query that you can use it to get differences of two dates using sysdummy1.

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

Related Posts

Author: Srini

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