there is a user table

int | varchar | varchar id | name | last_visit 13 | Гоша | 12.05.2017 15:30 14 | Тоша | 10.05.2017 12:31 и т.д.

Is it possible to somehow pull the data from this table in order to make a selection in the query, where Last_Visit, for example, today. Without regard to time.

A rough example: where last_visit = '12 .05.2017 '

    1 answer 1

    Convert the last_visit to date.

     SELECT * FROM user WHERE str_to_date(last_visit,'%d.%m.%Y')='20170512'

    Example - http://sqlfiddle.com/#!9/b9debe/13