Substract ! month from date

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
reddy
Premium Member
Premium Member
Posts: 168
Joined: Tue Dec 07, 2004 12:54 pm

Substract ! month from date

Post 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!!!
Top
vive1005
Participant
Posts: 2
Joined: Wed Aug 27, 2008 12:44 am
Location: Mumbai

Post by vive1005 »

You can use " Select T.Date_Field - 1 month From Table T"

Regards,
Vivek,
DataStage Developer
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”