Hello! I have in the table two fields time_1 and time_2 they store time for example 17:00:00 and 02:00:00 I need to print those lines where real time is more time_1 and less time_2. All would be nothing but if now, for example, 18:00:00, then the second condition will not work since 18 is more than 2. And now I can’t figure it out. I do not need to add a date. Tell me how you can correctly make a condition?
- Without the date 2:00 AM will never be later than 5:00 PM. - Mikhail Vaysman
- Then another question is how to store this data? This is the mode of operation, and each entry has its own. From 10 to 20, from 9 to 13, from 11 to 1 for example. Those. in fact, the date is not needed here. - Sai
- onefor example, the beginning of the period and the duration - Mikhail Vaysman
- Thanks, I will ponder) - Sai
|