Difference between two dates

[ncbshiva]

I have a log that has
Start date=2003-11-20 00:00:00,End date=2079-06-06 00:00:00.
I want to calculate the difference between the Enddate and Startdate, and display the difference in both days and in years.

Please help me

[martin_mueller]

For days you can do this:

...  | eval days = round((strptime(Enddate, "%F %T") - strptime(Startdate, "%F %T")) / 86400)

For years it depends on what you want to see.