Core iTOps Tube

Wednesday, 9 May 2012

Convert Date from File and Calculate Duration

Hi - I am looking for a little help to read in 2 date fields from a file in format:



20120508134012.3

yyyymmddhhmmss.tenths of a second



So i want to:

1. Read in the 1st date from the file

2. Read in the second date from the file

3. Calculate the difference in minutes (or seconds)

4. Append the line of the original file with the "duration".



I am guessing the best approach would be to convert the date/times to epoch time, and subract. I have been searching the threads, but have not come up with anything. Any thoughts?



Thanks!




No comments:

Post a Comment