如何在mysql中重新格式化datetime？

Question

QUESTION 1 : I am using datetime to store the date and time in MySQL. I use MySQL Now() function to insert datetime. How do I store the the date using a different format? From : Year-Month-Day Hour:Mins:Sec to : Day-Month-Year Hour:Mins:Sec.

QUESTION 2 : How can I retrieve only a specified part (day, month, year, etc.) of the date stored above?

Answer 1

You did not understand, mysql accept date format only in yyyy-mm-dd. you can not change the standard of mysql.

Although you can retrieve date in different format using mysql in-built functions.

Look at the date and time functions of mysql you can retrieve date in any format then why do you need to change the storage format.