Filtering on time on a datetime field using SqlAlchemy + python

Question

I have a LocationEvent model which has a timestamp property which is a DateTime field. I want to write a function which will take a start_time and end_time (which are python time objects) and will return the LocationEvent objects which are between those two times - irrespective of the date.

I tried using the extract function in SQLAlchemy but was not able to succeed. I tried the following -

LocationEvent.query.filter(sqlalchemy.extract('time', LocationEvent.timestamp) >= start_time)

This gives me the following error -

sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version for the right syntax to 
use near 'time FROM location_event.timestamp) >= '08:00:00'' at line 3") 'SELECT 
location_event.id AS location_event_id, location_event.latitude AS location_event_latitude, 
location_event.longitude AS location_event_longitude, location_event.type AS 
location_event_type, location_event.timestamp AS location_event_timestamp, 
location_event.creation_date AS location_event_creation_date \nFROM location_event \nWHERE 
EXTRACT(time FROM location_event.timestamp) >= %s' ('08:00:00',)

Any idea on how can I achieve this?

EXTRACT is not supported by sql server.

zs2020
– zs2020

2014-07-08 13:53:40 +00:00
Commented Jul 8, 2014 at 13:53 — zs2020
– zs2020, Commented Jul 8, 2014 at 13:53

Siddharth · Accepted Answer · 2014-07-08 10:14:38Z

3

I was able to do this using the following -

from sqlalchemy import Time, cast
LocationEvent.query.filter(cast(LocationEvent.timestamp, Time) >= start_time, cast(LocationEvent.timestamp, Time) <= end_time).all()

answered Jul 8, 2014 at 10:14

Siddharth

5,21913 gold badges51 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Filtering on time on a datetime field using SqlAlchemy + python

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