Question 199619 in Mysql Question posted in
The official MySQL documentation can be found here.

How to convert any date format to "dd/mm/yyyy" in mysql

I am struggling with one issue in mysql.

Can anyone please suggest me, How to convert any date format to "dd/mm/yyyy" in mysql.

Tags:

2

Answers


  1. 0

    You need to add a predefined function in the query.

    SELECT DATE_FORMAT(fieldName,’%D/%M/%Y’) AS format_registration_datetime
FROM fieldNameTitle;
    Login or Signup to reply.
  2. 0

    try this:

    SELECT *, DATE_FORMAT(date,'%d/%m/%Y') AS formatedDate FROM table;
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search