Subtract Days from a timestamp field?

[guscobol]

Does anyone know how to subtract days from a timestamp field?
I have seen this work in other programs using CURRENT TIMESTAMP:

CURRENT TIMESTAMP - 62 DAYS

But when I try to do it using my timetamp field I get an error.

TB01025-EFF-TMSTAMP - 62 DAYS


Thanks,

[Terry Wincheste]

Re: Subtract Days from a timestamp field?

In ILE/Cobol you can use the intrinsic function subtract-duration.

move function SUBTRACT-DURATION (WS-Old-Date DAYS 1) to WS-New-Date

Here's an article on computing differences between two dates that illustrates other examples of instrinsic date functions:

http://www.iseries-cobol.com/blog/2008/01/21/calculating-the-difference-between-dates/

Here's a link to the ILE/Cobol reference manual for V5R3:

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/books/sc092539.pdf

Terry

[guscobol]

Re: Subtract Days from a timestamp field?

Thank you for your response.
This is what ended up working for me...

Where
DATE(A.DB_TMSTAMP) > DATE(:TB01025-EFF-TMSTAMP) -
62 DAYS