[Sqlalchemy-tickets] Issue #3533: PostgreSQL 24:00:00 time provokes exception (zzzeek/sqlalchemy)

[hasier <iss...@bi...>]

New issue 3533: PostgreSQL 24:00:00 time provokes exception
https://bitbucket.org/zzzeek/sqlalchemy/issues/3533/postgresql-24-00-00-time-provokes

hasier:

In PostgreSQL, a value of 24:00:00 in a time type column is valid, but Python only accepts a max of 23:59:59.999999. Therefore it breaks with 'ValueError: hour must be in 0..23' when retrieving it.

P.S.: I guess it would be a better practice to store 23:59:59.99 in the DB as the SQL standard says, but I think it should be somewhat managed anyway, transforming the retrieved value to 23:59:59.99.