Answer the question
In order to leave comments, you need to log in
Is it possible to search for time between marks and with a time zone from the database?
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 the question
In order to leave comments, you need to log in
Look here
SELECT TIME_FORMAT( NOW() - UTC_TIMESTAMP(), '%H%i' ) AS tz_offset;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question