In this article, we will discuss how to get the difference between two datetimes in microseconds in python.

Python provides a datetime module for manipulation of date and time. It consists of following classes,

  • datetime.date: An object of date class specifies a date using year, month and day
  • datetime.time: An object of time class specifies a timestamp using hour, minute, second, microsecond, and tzinfo.
  • datetime.datetime: An object of datetime is a combination of a date and a time.
  • datetime.timedelta: A duration, that represents the difference between two dates or times or datetimes.
  • datetime.tzinfo: It contains the timezone information.

Now to get the difference between two timestamps in python, we will use the datetime module. First we will create start and end datetime objects from the string timestamps. Then we will subtract the datetime objects to get the duration in the datetime.timedelta object. Then using the properties of timedelta object, we will fetch the microseconds in between the two timestamps. Let’s understand with some examples,

Python Example 1: Get difference between two timestamps in microseconds

Convert the timestamps from string format to datetime objects. Then subtract them and get the timedelta object. Then use the total_seconds() function of timedelta to get the complete duration between two timestamps in seconds and then convert it to microseconds. For example,

from datetime import datetime

date_1 = '24/7/2021 11:13:08.230010'
date_2 = '24/7/2021 11:14:18.333338'

date_format_str = '%d/%m/%Y %H:%M:%S.%f'

start = datetime.strptime(date_1, date_format_str)
end =   datetime.strptime(date_2, date_format_str)

# Get the interval between two datetimes as timedelta object
diff = end - start

# Get the interval in microseconds
diff_in_micro_secs = diff.total_seconds() * 1000000

print('Difference between two datetimes in micro seconds:')
print(diff_in_micro_secs)

Output:

Difference between two datetimes in micro seconds:
70103328.0

How did it work ?

We createed the two datetime objects from the two timestamps in the string format, by passing the date and it’s format in the strptime() function. Then we subtracted these two datetime objects and got the datetime.timedelta object, which represents the duration between two dates. The timedelta class has a member function total_seconds(), which represents the complete duration in seconds (including the fractional part till milliseconds). We used that to fetch the difference bewteen two timestamp in seconds and then we converted it to microseconds by multiplying by 1000000.

Python Example 2: Get difference between two timestamps in microseconds

Let’s checkout an another example, where both the timestamps are more than 1 day apart,

from datetime import datetime

date_1 = '24/7/2021 11:13:08.230010'
date_2 = '25/7/2021 11:14:18.333338'

date_format_str = '%d/%m/%Y %H:%M:%S.%f'

start = datetime.strptime(date_1, date_format_str)
end =   datetime.strptime(date_2, date_format_str)

# Get the interval between two datetimes as timedelta object
diff = end - start

# Get the interval in microseconds
diff_in_micro_secs = diff.total_seconds() * 1000000

print('Difference between two datetimes in micro seconds:')
print(diff_in_micro_secs)

Output:

Difference between two datetimes in micro seconds:
86470103328.0

Python Example 3: Get difference between two timestamps in microseconds

Let’s checkout an another example, where both the timestamps are more than 2 years apart,

from datetime import datetime

date_1 = '2/7/2021 21:55:12.230010'
date_2 = '24/9/2023 11:13:08.333338'

date_format_str = '%d/%m/%Y %H:%M:%S.%f'

start = datetime.strptime(date_1, date_format_str)
end =   datetime.strptime(date_2, date_format_str)

# Get the interval between two datetimes as timedelta object
diff = end - start

# Get the interval in microseconds
diff_in_micro_secs = diff.total_seconds() * 1000000

print('Difference between two datetimes in micro seconds:')
print(diff_in_micro_secs)

Output:

Difference between two datetimes in micro seconds:
70291076103328.01

Python Example 4: Get difference between two datetimes in microseconds

If we have complete datetime objects instead of only timestamp strings, in that case lets see how to calculate the difference between two datetimes in microseconds,

from datetime import datetime

date_1 = datetime(2021, 7, 2, 21, 55, 12)
date_2 = datetime(2021, 7, 24, 11, 13, 8)

# Get the interval between two datetimes as timedelta object
diff = date_2 - date_1

# Get the interval in microseconds
diff_in_micro_secs = diff.total_seconds() * 1000000

print('Difference between two datetimes in micro seconds:')
print(diff_in_micro_secs)

Output:

Difference between two datetimes in micro seconds:
1862276000000.0

Python Example 5: Get difference between two datetimes in microseconds using pandas

Suppose we have two timestamps in string format. We can convert them to datetime object using pandas.to_datetime() function. Then we will subtract the datetime objects to get the duration in the datetime.timedelta object. Then using the properties of timedelta object, we will fetch the total seconds in between the two timestamps (including the fractional part till milliseconds) and then multiply that by 1000000 to get the complete duration in microseconds. For example,

import pandas as pd
from datetime import datetime

date_1 = '2/7/2021 21:55:12.230010'
date_2 = '24/9/2023 11:13:08.333338'

date_format_str = '%d/%m/%Y %H:%M:%S.%f'

start = pd.to_datetime(date_1, format=date_format_str)
end = pd.to_datetime(date_2, format=date_format_str)

# Get the interval between two datetimes as timedelta object
diff = end - start

# Get the interval in microseconds
diff_in_micro_secs = diff.total_seconds() * 1000000

print('Difference between two datetimes in micro seconds:')
print(diff_in_micro_secs)

Output:

Difference between two datetimes in micro seconds:
70291076103328.01

Summary:

We learned that, in python how to get the difference between two datetimes in microseconds.