How to change datetime format in mysql to display as dd.mm.yyyy MM:HH?

Question

MySQL

How to change datetime format in mysql to display as dd.mm.yyyy MM:HH and not US format?
And another question. What are you using -datetime or timestamp ?
Thanks

Answer 1

datetime in mysql is stored internally in a non-American format, it is simply displayed like this by default, you cannot change it, but you can specify the format in the request:
dev.mysql.com/doc/refman/5.6/en/date-and-time-func...

Answer 2

Use TEXT then.