How to filter the datetime column in a SQL table with SQLalchemy in python?

user_9779999 0
Viewed 277

I have a SQL table, and I query the table with SQLalchemy with python.

goog = pd.read_sql("\
\
SELECT dp.price_date, dp.adj_close_price \
FROM symbol AS sym \
INNER JOIN daily_price AS dp \
ON dp.symbol_id = sym.id \
WHERE sym.ticker = 'GOOG' \
ORDER BY dp.price_date ASC",

con = engine,
index_col='price_date')

enter image description here

Now my problem is, the price_date data type is datetime, I tried to filter in the WHERE clause, but failed. Like this:

price_date BETWEEN 2021-11-08 00:00:00.00000 AND 2021-11-12 00:00:00.000000

and this:

price_date BETWEEN 2021-11-08 AND 2021-11-12

Any solution?

filtering sqlalchemy datetime mysql python
1 Answers
user_51935360
Related