Home php How to change date format on query in mysql

How to change date format on query in mysql




How to change the date format when querying in MySQL, I write the date into the database via NOW () and it has the format YYYY-MM-DD HH-MM-SS , to me you need the date to be in the d: m: YH: i format when the record is received.
To do this, I make a request using

DATE_FORMAT (): SELECT * DATE_FORMAT (date, '% d /% m /% Y% H:% i') FROM comm.

But the date is still in the form YYYY-MM-DD HH-MM-SS . What is the mistake?

Answer 1, authority 100%

What type of field? There should be DateTime , and this is how your function works fine:

SELECT DATE_FORMAT ('2018-07-25 18:01:02', '% d /% m /% Y% H:% i ')


07/24/2018 05:03

Answer 2, authority 100%

php has a great date function: http://php.net/manual/ ru / function.date.php . By installing the desired filter, you will get the desired result.

date ("D.m.Y", strtotime ($ datetime))

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions