Date time difference using Ansible

Question

How to calculate the difference in seconds between below two date variables using Ansible.

date1: 06/01/2021 00:10:15.434 date2: 06/01/2021 00:10:26.667

Tried to_datetime gives does not match format '%Y-%m-%d %H:%M:%S' error. If the dates are in yyyy-mm-dd format the difference calculation works, but not getting with above date format.

Does this help? https://stackoverflow.com/questions/48101921/ansible-compare-difference-between-two-dates-for-the-last-hour — Will Walsh, Jun 01 '21 at 05:01

Will Walsh · Answer 1 · 2021-06-01T05:27:55.407

1

Assuming 06/01/2021 is in the month, date, year format, use this code.

((date2 | to_datetime('%m/%d/%Y %H:%M:%S.%f')) - (date1 | to_datetime('%m/%d/%Y %H:%M:%S.%f')).total_seconds()

edited Jun 01 '21 at 05:27

answered Jun 01 '21 at 05:03

Will Walsh

1,799
1
6
15

Tried this various ways, gives an templating error and format issues. – Sumith Jun 01 '21 at 05:20
Am getting these date vars from a long string, not ansible_date_time fact – Sumith Jun 01 '21 at 05:23
had used the same, gives 'datetime.datetime object' has no attribute 'total_seconds' – Sumith Jun 01 '21 at 05:38
datetime.datetime.total_seconds is new in Python 3.2. Which version of Python is Ansible using? – Will Walsh Jun 01 '21 at 05:45
Yes, it's older one. I'll try in our latest env and update here. – Sumith Jun 01 '21 at 05:50

Date time difference using Ansible

1 Answers1