Simple life, Complicated mind
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:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment