You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Do you use a PostgreSQL SaaS? If so, which? Can you reproduce
the issue with a local PostgreSQL install?: this is happening on local PG
Python version: 3.11.7
Platform:
Do you use pgbouncer?: no
Did you install asyncpg with pip?: yes
If you built asyncpg locally, which version of Cython did you use?:
Can the issue be reproduced under both asyncio and uvloop?: yes
Python's timedelta implementation only allows to store negative number of days, hours, minutes, seconds, microseconds are always positive values. So when a negative value smaller than a day is interpreted it is stored in a strange way, example from Python's documentation:
Note that normalization of negative values may be surprising at first. For example:
>>> from datetime import timedelta
>>> d = timedelta(microseconds=-1)
>>> (d.days, d.seconds, d.microseconds)
(-1, 86399, 999999)
the issue with a local PostgreSQL install?: this is happening on local PG
uvloop?: yes
Python's timedelta implementation only allows to store negative number of days, hours, minutes, seconds, microseconds are always positive values. So when a negative value smaller than a day is interpreted it is stored in a strange way, example from Python's documentation:
Note that normalization of negative values may be surprising at first. For example:
https://docs.python.org/3/library/datetime.html?highlight=timedelta#datetime.timedelta
In my particular case when I'm trying to store -3 hours, that's getting translated in python to:
And ends up stored in postgresql as: "0 years 0 mons -1 days 21 hours 0 mins 0.0 secs"
Is there also a workaround where I can skip timedelta for interval?
The text was updated successfully, but these errors were encountered: