wright67uk Posted January 6, 2013 Share Posted January 6, 2013 I have a list of dates in a varchar column 'sdate', in the following format dd/mm/yyyy I would like to change above the column type to date, and change all entries in the column to this format: yyyy-mm-dd Is this possible in an sql query? Link to comment https://forums.phpfreaks.com/topic/272774-sql-change-to-and-edit-the-format-of-dates/ Share on other sites More sharing options...
Barand Posted January 6, 2013 Share Posted January 6, 2013 Update query using STR_TO_DATE() Link to comment https://forums.phpfreaks.com/topic/272774-sql-change-to-and-edit-the-format-of-dates/#findComment-1403749 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.