Convert mysql date format YYYY-MM-DD to DD, MM, YYYY
by Ramya[ Edit ] 2012-11-03 19:40:32
Convert mysql date format YYYY-MM-DD to DD, MM, YYYY:
You can Convert mysql date format YYYY-MM-DD to DD, MM, YYYY using the DATE_FORMAT() in mysql,
SELECT DATE_FORMAT(table.fieldname,'%e %m, %y') FROM tablename
