Tag: Date Series in DB2

Miscellaneous

How to create a Date Series in DB2 (DBA DB2)

Question: How can I create a Date Series  in DB2 LUW. e.g. 01-01-2017 to 30-01-2017 . ? Answer:  There are a number of different ways to create a date series in DB2 LUW.One way is the example used below, which lists the dates from 1st January 2017 – 30 January 2017. : db2 “with tempdateseries (date) …