Select records which are 1 month old using sql query

rohanatl · New User Joined: 21 Oct 2005 Posts: 20

HI All,
i want to retrieve the records from the db2 table where the condition is one month old from the date available in the table.
There is a field called date1 which will contain the date in which the records are inserted to the table,
i dont want to change the query every time,Can any one give me a query which will perform the same.
select * from Table name where date = one month old

arcvns · Posted: Mon Sep 22, 2008 9:56 am Post subject:

Hello,

You can try something like this.

ksk · Posted: Mon Sep 22, 2008 10:21 am Post subject:

Refer the following link.

http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip3.html

KSK

murugan_mf · Posted: Mon Sep 22, 2008 3:06 pm Post subject:

can you try this,

stodolas · Posted: Tue Sep 23, 2008 9:00 am Post subject:

There are months that have more or less than 30 days. The - 30 DAYS calculation is garbage from a pure calendar point of view.