schedule after 0:00 hour not working before first interval

57 views Asked by At

I have a table with 4 schedule interval:

id  time_int    progr_comment   A   B   C   D
1   05:30:00    Good Morning    1   4   2   17
2   06:50:00    Have a nice day 1   4   2   17
3   17:00:00    Welcome Home    1   4   4   23
4   18:30:00    Good Evening    1   4   2   22
5   22:00:00    Good Night      1   4   2   20

For each interval I compare with NOW() and I will take the variables (A, B, C, D) from table based on time_int <= NOW() then my program create a query to mysql. The problem come after 0:00 hour. The query does not find anything until NOW() pass the first interval (ex. 5:30:00).

0

There are 0 answers