Saving Time into Postgres database using SQLAlchemy

Question

I have a Python application which utilizes SQLAlchemy to interface with a Postgres database. I am running into some issues saving a time object into the database.

I define two time columns where db is a SQLAlchemy object:

offHours                = db.Column(db.Time)
onHours                 = db.Column(db.Time)

Elsewhere in the code, I try to save a time value from a string:

offHours = "06:23"
onHours = "14:34"

Python then throws the following:

time data '06:23' does not match format '%HH:%MM'

I am confused by this error because the input is a valid 24 hour time. Additionally, the Python docs state that the correct formatter for a 24 hour timestamp is '%H:%M'. If this is the case, why is SQLAlchemy using '%HH:%MM' as it's time formatter?

In short, what am I doing wrong when saving these times? Is it my input or possibly some issue with my database configuration?

It may be that the quotes are required to match exactly.

Adam
– Adam

2015-12-17 20:46:28 +00:00
Commented Dec 17, 2015 at 20:46 — Adam
– Adam, Commented Dec 17, 2015 at 20:46

Nidhin Bose J. · Accepted Answer · 2016-07-10 12:06:10Z

1

Try saving datetime.time object and not string.

answered Jul 10, 2016 at 12:06

Nidhin Bose J.

1,09215 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving Time into Postgres database using SQLAlchemy

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related