select CONVERT(datetime, (RIGHT(LEFT(datecolumn,5),2) + '/'+LEFT(datecolumn,2)+'/'+ RIGHT(LEFT(datecolumn,10),4)+ SUBSTRING(datecolumn,11, len(datecolumn))), 120) as datefield FROM DatesTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)