Is it possible to search for time between marks and with a time zone from the database?

Question

MySQL

How to save and search the time when the store is open? The biggest problem is that it can be open from 8am to 1am. Then 1 < 8 and the between operator will not help in the search at all. How to be and in what format to save?

Answer 1

Look here

SELECT TIME_FORMAT( NOW() - UTC_TIMESTAMP(), '%H%i' ) AS tz_offset;