MySQL - extract data between now and 7:00 in the morning

Question

I'm tryin without success to get datas from a database between now and 7:00 am

I've tried this, it returns datas but it's the wrong ones for 7:00

SELECT *, MIN(AMBIENT_TEMPERATURE) AS min_temp, 
       MAX(AMBIENT_TEMPERATURE) AS max_temp
FROM WEATHER_MEASUREMENT
WHERE DATE(CREATED) = CURDATE() AND TIME(CREATED)>='07:00:00'

I think this is pretty easy but still too difficult for me.

thanks.

jerome

7:00 a.m. tomorrow or today. Please be explicit about the time frame you want to return. — Gordon Linoff, May 06 '16 at 12:04
have a look at this http://stackoverflow.com/questions/18592777/trying-to-count-mysql-data-between-time1-and-time2?rq=1 — piyushj, May 06 '16 at 12:07
I would like 7:00 am today, moreover it'st not exactcly 7:00 am, it may be 7:01 or 7:00:12, ... — JEROME C, May 06 '16 at 12:42

score 0 · Answer 1 · answered May 06 '16 at 13:51

Just as you used the DATE function to determine if the row was from the correct day, use the HOUR function to determine if the row is from the correct hour.

I don't really understand from your question which rows you are trying to get back, all of the ones from today in the 7am hour? All of the ones from today before 7am? It isn't clear. This will give you the ones before 7am: SELECT *, MIN(AMBIENT_TEMPERATURE) AS min_temp, MAX(AMBIENT_TEMPERATURE) AS max_temp FROM WEATHER_MEASUREMENT WHERE DATE(CREATED) = CURDATE() AND HOUR(CREATED)<7

MySQL - extract data between now and 7:00 in the morning

1 Answers1