F
F
fortael2017-08-09 22:34:29
MySQL
fortael, 2017-08-09 22:34:29

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

1 answer(s)
H
heartdevil, 2017-08-09
@fortael

Look here

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question