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

Discover more from Srinimf

Subscribe now to keep reading and get access to the full archive.

Continue reading