Filter for one date from DateTimeTZRange

jimmy 0
Viewed 29

I have a model which returns the date range in below mentioned way i need to check if today is 10 days before the days as you can see in the below returned date if today date + 10 days = start_end_range

class MyModel(models.Model):
    start_end_range = ranges.DateTimeTZRange()


'start_end_range': DateTimeTZRange(datetime.datetime(2022, 11, 30, 20, 0), datetime.datetime(2022, 11, 30, 20, 30),
django-orm django-queryset postgresql django python
1 Answers

A first draft of a solution. This is based on some assumptions, namely that you want the date check to be ==.

from datetime import datetime, timedelta 
from psycopg2.extras import DateTimeTZRange

dtr = DateTimeTZRange('2022-08-08 06:00', '2022-08-08 8:30') 

d = dtr.lower
d                                                                                                                                                            
'2022-08-08 06:00'

start_date = datetime.fromisoformat(d)                                                                                                                                      
start_date
datetime.datetime(2022, 8, 8, 6, 0)

test_dt = datetime(2022, 7, 25)
(test_dt + timedelta(days=10)) ==  start_dt
False
Adrian Klaver0
Related