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? Quote 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() Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.