Change the date and time format in SORT.

[Neeraj N]

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]

What have you tried?

[Neeraj N]

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?