How to change date format in MySQL?

Question

PHP

In my column, the date is written in this way 1915-12-29 05:56:31
As a result, now there are problems with indexing. I believe the date is the problem. How to change the date format to one that could be indexed normally? Or what is the problem and how to solve it?

Answer 1

What does the type of date record in the database have to do with site indexing? It can be written to the database even in unix, but how your site displays the date is the second question.