Wednesday, August 27, 2014

How to convert date format in MySQL

SELECT DATE_FORMAT(STR_TO_DATE('08/07/2014', '%m/%d/%Y'), '%Y-%m-%d')

SELECT DATE_FORMAT(STR_TO_DATE('8/7/2014', '%c/%e/%Y'), '%Y-%m-%d')

No comments: