Page 1 of 1

Substract ! month from date

Posted: Thu Sep 10, 2009 1:40 pm
by reddy
Hi Guyz,

Hope you are doing fine!!!

i got a quick question:

can someone please let me know how to Substract 1 month from date column in SQL on db2 Database?


Thanks in Advance!!!

Posted: Mon Sep 14, 2009 7:12 am
by vive1005
You can use " Select T.Date_Field - 1 month From Table T"

Regards,