How to compare a date in a selection from a database?

Question

PHP

I have a date stored in the database in this form 2016-02-04 12:30:00 and
there is a variable that is compared with it in this form 2016-02-04 , that is, without time
For them to be equal

Answer 1

datecolumn >= '2016-02-04' and datecolumn < '2016-02-04' + interval 1 day

If someone will offer at first glance a more compact solution date(datecolumn) = '2016-02-04' - immediately consider that such a condition in mysql, in principle, cannot use indexes.

Answer 2

You can try to do STR_TO_DATE('2011-12-21 02:20pm', '%Y-%m-%d %h:%i%p') and compare numbers already, which is more convenient, although it depends on the column type, if line - it will definitely be bad. If possible, it's better not to store the date in this form, IMHO.