Why can't this be done?

Question

PHP

SELECT `table_name`, `table_name2` FROM `db_name` WHERE '1447372799' - UNIX_TIMESTAMP(`time`) > 0 AND '1447286400' < UNIX_TIMESTAMP(`time`);

Answer 1

Use BETWEEN in the comparison condition, just pass in the 2 constructed dates/values ​​you need.

WHERE UNIX_TIMESTAMP(`time`) BETWEEN dateA and dateB

Answer 2

because:

SELECT список полей FROM список таблиц WHERE условия…

Answer 3

And how to be? If it is necessary to receive unixtime from datetime?

Any date can be used, just gave an example.