MVSFORUMS.com

misi · Beginner Joined: 14 Apr 2004 Posts: 13 Topics: 10

I have a program which should generate monthly report. The report can be run on any day of the month. The SQl query should retrieve all records which has been inserted for the last 1 month from the current date. A timestamp field is present in the table. How do I write the query to retrieve the last 1 months data If i run the query on any day of the month. Last month can have 30 or 31 days or 28 or 29 days..So accordingly my query should calculate the start date and obviously the end date is the current date.

misi

kolusu · Posted: Wed Apr 21, 2004 11:56 am Post subject:

Misi,

If you are using DB2 Version 7 then you can use the function LAST_DAY to get the last day of every month