开发者

HOw to add 1 day to the given input date (format: YYYY-MM-DD) using JCL Syncsort?

开发者 https://www.devze.com 2023-04-12 23:12 出处:网络
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?

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

0

精彩评论

暂无评论...
验证码 换一张
取 消