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.
Change the date and time format in SORT.
Re: Change the date and time format in SORT.
I used like following :
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?
Code: Select all
OUTREC FIELDS=(16,4,12,2,10,2)
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute