I want to add 1 day to the given input date. The input date is in YYYY-MM-DD format.
Can anybady please let me know how can I do this using Syncsort?
Ex:
Input date: 2011-10-31 (Format: YYYY-MM-DD)
Output date after add 1 day: 2011-11-01 (Format: YYYY-MM-DD)
Thank you, Raja开发者_如何学编程sekhar Jannu.
You can use DATEADD in Syncsort MFX for z/OS 1.4 to add one day.
Example syntax (where p= field position and l= field length):
OUTREC FIELDS=(...DATEADD=(p,l,DT=(4MD-),+1,DAY),...)
Please contact zos_tech@syncsort.com if you require further assistance.
Brian Wood Customer Service Representative Syncsort Incorporated 201-930-8260
精彩评论