Have you looked up the pieces of this?
What does DATE() do?
What does the MONTHS do?
If you knew that, the rest would be simple....
Do you need help finding a manual?
Do you want somebody to look up the answer for you?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello Mauvis, and welcome to the forums,
If you are learning your way around this site, the manuals most often used are linked to the top of each web page as "Manuals". There is also a "Search" feature (see below).
What you have is an SQL statement that takes advantage of a DB2 feature.
When you are going to ask a question, it is good practice to search the forums for an existing answer (this has been discussed before). If you find what you need by searching, you will save time waiting on an answer from the forum.
Please search and/or refer to the DB2 manuals and post back if there is anything not clear. It is probably more important to learn how to use this site and the documentation than it is to have someone just spout back answers.