Change the date and time format in SORT.

SyncSort's Sort Product, SyncTool for z/OS, SYNCINIT and SYNCLIST.
Previous topicNext topic

Topic Author
Neeraj N
Registered Member
Posts: 43
Joined: Tue Aug 20, 2013 12:49 pm

Change the date and time format in SORT.

Post by Neeraj N » Thu Oct 12, 2017 9:46 pm

Hi,

There is a flat file of LRECL 500 and 1500 records. From column 10 date and time field start and they are in the format of DD.MM.YYYY and HH:MM:SS respectively.I want to copy this data in the output with all the fileds as is but date and time changed to the format YYYYMMDD and HHMMSS. How can I do that, please help.




nicc
Global Moderator
Global Moderator
Posts: 583
Joined: Wed Apr 23, 2014 8:45 pm

Re: Change the date and time format in SORT.

Post by nicc » Fri Oct 13, 2017 2:54 pm

What have you tried?


Regards
Nic


Topic Author
Neeraj N
Registered Member
Posts: 43
Joined: Tue Aug 20, 2013 12:49 pm

Re: Change the date and time format in SORT.

Post by Neeraj N » Sat Nov 25, 2017 8:43 am

I used like following :

Code: Select all

OUTREC FIELDS=(16,4,12,2,10,2) 
as my date starts from column 10 in my input file. But I want to if there is a format which can directly understand DD.MM.YYYY, date with dots?



Previous topicNext topic

Return to “SyncSort, SyncTool, SyncGener.”