Can't subtract offset-naive and offset-aware datetimes

Question

I have a timezone aware timestamptz field in PostgreSQL. When I pull data from the table, I then want to subtract the time right now so I can get its age.

The problem I'm having is that both datetime.datetime.now() and datetime.datetime.utcnow()seem to return timezone unaware timestamps, which results in me getting this error:

TypeError: can't subtract offset-naive and offset-aware datetimes

Is there a way to avoid this (preferably without a third-party module being used).

Answer 1

If you can't subtract offset-naive and offset-aware datetimes you should try to remove the timezone awareness use the following:-

naive = dt.replace(tzinfo=None)

You may have to add time zone conversion as well. Another point to note that be aware of the age of this answer.