MVSFORUMS.com

pulsar · Beginner Joined: 09 May 2007 Posts: 10 Topics: 3

Is it possible to write a query where i can fetch rows updated in last three days.

Eg:
Select Val1 from Table1 where
last updated date > current date - 3

Note:
Last updated date is a column in table.

[/code]

CraigG · Posted: Tue Nov 27, 2007 7:36 am Post subject:

Yes

WHERE LAST_UPDATED_DATE > CURRENT DATE - 3 DAYS

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Pulsar,

Yes you can. You can directly pass the value too like
WHERE LAST_UPDATED_DATE > '11.24.2007'

pulsar · Beginner Joined: 09 May 2007 Posts: 10 Topics: 3

Thanks CraigG & vkphani.

But now the problem is getting the Current date. how can i get it for any table?

CraigG · Posted: Tue Nov 27, 2007 8:27 am Post subject:

pulsar · Beginner Joined: 09 May 2007 Posts: 10 Topics: 3

thanks CraigG.

I got it using

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

Pulsar,
You shouldn't need to get the CURRENT DATE from any table. As Craig G. mentioned it's in a special register. Just by referencing it in your SQL it should know what the value of CURRENT DATE is.