This question has already been answered:

How to change datetime format in mysql to display in the form dd.mm.yyyy MM:HH and not in the US format?

And one more question. What do you use - datetime or timestamp?

Reported as a duplicate by BOPOH participants, cyadvert , JuriySPb , aleksandr barakin , Qwertiy 16 Dec '15 at 9:18 .

A similar question was asked earlier and an answer has already been received. If the answers provided are not exhaustive, please ask a new question .

  • Do you not confuse a month with minutes? And what ММ:HH ? - Qwertiy
  • Well, yes ... the point is that first day-month-year. Probably I will use the usual bigint and store the timestamp there, but the troubles on the client, how to translate normally? - Rakzin Roman
  • And why is there bigint? - Qwertiy
  • Offer the option on the client to display in the day / month / year format and send it to the server; it is not important to store it, and when loading, the display is in normal form. So I’ve been carrying something for the second day with a date, I can’t figure out how to be? - Rakzin Roman

1 answer 1

Judging by the manual , it should be like this:

 DATE_FORMAT(NOW(), '%d.%m.%Y %H:%i')