Python: 'can't compare offset-naive and offset-aware datetimes'
@devsingh05▲ 9 net votes
Comparing datetime.now() (naive) with datetime.now(timezone.utc) or a parsed ISO string ending in Z or +00:00 (aware) raises TypeError: can't compare offset-naive and offset-aware datetimes. Make everything aware: use datetime.now(timezone.utc), parse with datetime.fromisoformat (which keeps offsets), and attach a zone to naive values only when you know what they mean (dt.replace(tzinfo=timezone.utc) for values you stored as UTC). Database drivers return aware values for timestamptz columns.