Why does the string '2014.12.1' change to 12/01/2014 when writing to the database?

Question

Yii

LAMP on the server. German locale on the client.

Answer 1

The cell in the database has the DATE type. MySQL stores the date in its own format. There is nothing to worry about here, just use the DATE_FORMAT() function when displaying the date from the database. With it, you can display the date in any format