My requirement is to fire query on table and fetch data wher

bhamarekm · New User Joined: 20 Sep 2010 Posts: 9 Location: Pune

Hi All,

My requirement is to fire query on table and fetch data where condition date = current date – 3 days. I wan result using query only.
Does anyone let me know is there any in build function like Current date in DB2?

Thank you on advance.
Kiran

Craq Giegerich · Posted: Mon Sep 20, 2010 5:44 pm

enrico-sorichetti · Posted: Mon Sep 20, 2010 5:48 pm

a google search DB2 CURRENT DATE returns 209000 hits
( the number might change depending on the google/browser settings )

like for example
www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html

anyway the bible is the manual, for which You can click the link at the top of the page

Anuj Dhawan · Posted: Mon Sep 20, 2010 5:49 pm

Please have a look here, if it helps you: www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html

bhamarekm · New User Joined: 20 Sep 2010 Posts: 9 Location: Pune

Yes this help me

thank for your valuable inputs Anuj and enrico .

Anuj Dhawan · Posted: Mon Sep 20, 2010 5:57 pm

Good Luck.