Search first name in mysql field before MYSQL space

Question

I have to look for a date in a mysql field, but the guys had put it to save like this "2016-02-21 14:02:01" I just need the date from there , as I can check on select the date I want comparing to that date?

Answer 1

select date(nomedacoluna) from minhatabela

more details on mysql date()

Answer 2

Like the @rray already answered, you can make a select by formatting the field, but this can take some of the performance.

For a more performative solution, I recommend using a clause BETWEEN as follows:

SELECT * FROM tabela WHERE campo BETWEEN '2016-02-21 00:00:00' AND '2016-02-21 23:59:59'

Answer 3

Can convert a datetime column to date only using cast(). Or by formatting the date with date_format()

SELECT * FROM tabela WHERE CAST(campo as date) = '2016-02-21'

or

SELECT * FROM tabela WHERE date_format(campo,'%Y-%m-%d) = '2016-02-21'