jpkunst on 12/06/11
Last Edited at 12/06/11 12:55am
SELECT CONCAT(SUBSTRING_INDEX(`textual_date`, '-', -1), '-', TRIM('-' FROM MID(`textual_date`, LOCATE('-', `textual_date`) + 1, 2)), '-', SUBSTRING_INDEX(`textual_date`, '-',1)) AS year_month_day FROM table;
Report this snippet Tweet
Comment:
You need to login to post a comment.