IBM Mainframe Forum

Hi All,

Could anyone help me in calculating the difference between two timestamp(26 char) fields in input file.

Sample input file record
2009-05-25-01.00.00.000000 2009-05-25-05.00.00.123456

Thank you,
Praveen Nayak

Why dont you post a few sample records and the expected output from it?

Sample input file records
Field 1 Field 2
2009-05-25-01.00.00.000000 2009-05-25-05.00.00.123456
2009-05-25-01.00.00.000000 2009-05-25-05.00.00.123456

expected output file records
2009-05-25-01.00.00.000000 2009-05-25-05.00.00.123456 ( field1-field2)
2009-05-25-01.00.00.000000 2009-05-25-05.00.00.123456 ( field1-field2)


Thank you
Praveen Nayak

Hello,

Now, please post the actual expected output - not the formula. . . .

expected output file records

SyncSort does not currently have the facility to perform arithmetic on date/time fields.