Re: Convert faulty string to date

[Harald Groven]

This is not an XML-related question, but a string function

You can split the elements of the date string by the ocurrences of "/" and concatenate the year, month and date virtual column.

SELECT
CONCAT(
'200', SUBSTRING_INDEX(datecolumn,'/',-1), '-',
SUBSTRING_INDEX(datecolumn,'/',1), '-',
SUBSTRING_INDEX(SUBSTRING_INDEX(datecolumn,'/',2),'/',-1)
)
FROM test
;



Edited 1 time(s). Last edit at 12/07/2008 05:59PM by Harald Groven.