Pick out rows between two dates that have the same time in SQL to Python

Question

I would like to import rows from mySQL database into Python. I would like to take out rows between two dates that have the same timstamp. I have managed to import between two dates with this line:

"SELECT * FROM table WHERE timestamp >= %s AND timestamp <=%s", (2020-03-07, 2020-03-10)

But I dont know how to spesific only rows where timestamp is for example 10:00:00. See picture for the database setup.

Database

how to spesific only rows where timestamp is for example 10:00:00 CAST this field to TIME datatype or format it to '%H:%i:%s' (i.e. remove date part), then compare with proper time literal. — Akina
– Akina, Commented Mar 10, 2020 at 12:45

Akina · Accepted Answer · 2020-03-10 12:49:39Z

2

You need something like

"""
SELECT * 
FROM table 
WHERE timestamp >= %s 
  AND timestamp <=%s 
  AND DATE_FORMAT(timestamp, '%H:%i:%s' = %s)
""", ("2020-03-07", "2020-03-10", "10:00:00")

answered Mar 10, 2020 at 12:49

Akina

43.2k6 gold badges17 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Pick out rows between two dates that have the same time in SQL to 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