How to change datetime resolution

Viewed 1386

Is there a simple way to state that

a = '2020-01-01 19:30:33.996628' 
b = '2020-01-01 19:30:34' 

a and b are equal. If the time resolution of a is changed to second, then a could be equal to b. How to implement it with code?

4 Answers

Set to next second

  • Add the timedelta difference between 1e6 and a.microsecond
from datetime import timedelta, datetime

a = datetime.fromisoformat('2020-01-01 19:30:33.996628')

a = a + timedelta(microseconds=(1e6 - a.microsecond))

print(a)

>>> datetime.datetime(2020, 1, 1, 19, 30, 34)

print(a.strftime('%Y-%m-%d %H:%M:%S'))

>>> 2020-01-01 19:30:34

Set to current second

  • With .replace(microsecond=0)
from datetime import datetime

a = datetime.fromisoformat('2020-01-01 19:30:33.996628')

print(a)

>>> datetime.datetime(2020, 1, 1, 19, 30, 33, 996628)

a = a.replace(microsecond=0)

print(a)

>>> datetime.datetime(2020, 1, 1, 19, 30, 33)

if you treat both of them as datetime objects, you can use arithmetic operators on them. For example, you can subtract them and check if the result satisfy a condition (like less then one minute different) as you wise

An easier way to use rounding for comparison:-

import datetime
from dateutil import parser

a = '2020-01-01 19:30:33.996628' 
b = '2020-01-01 19:30:34' 

a = parser.parse(a)
b = parser.parse(b)

a == b
False

format_str = '%Y-%m-%d %H:%M'

a_rounded = datetime.datetime.strptime(datetime.datetime.strftime(a, format_str), format_str)
b_rounded = datetime.datetime.strptime(datetime.datetime.strftime(b, format_str), format_str)

a_rounded == b_rounded
True

To this you can add flexibility according to your need like I have rounded up to comparison in Minutes. So in your case the format_str would be like this:-

format_str = '%Y-%m-%d %H:%M:%S'

The function datetime_round_s() below rounds to the closest second (like usual rounding of numbers):

import datetime

def datetime_round_s(date_time: datetime.datetime) -> datetime.datetime:
    return (date_time + datetime.timedelta(microseconds=5e5)).replace(microsecond=0)

a = datetime.datetime.fromisoformat('2020-01-01 19:30:33.996628')
b = datetime.datetime.fromisoformat('2020-01-01 19:30:34')

print(a)
print(datetime_round_s(a))
print(datetime_round_s(a) == b)

otuput:

2020-01-01 19:30:33.996628
2020-01-01 19:30:34
True
Related