Diary of problems and solutions related to web programming, database development and related technologies and platforms.

To change data format from mm/dd/yyyy to yyyy-mm-dd using MySQL

DATE_FORMAT(STR_TO_DATE(DateValueORColumnName, '%d.%m.%y'), '%Y-%m-%d')

No comments :

Post a Comment