DateTime dates = DateTime.ParseExact("20140415", "yyyyMMdd", CultureInfo.InvariantCulture)
SELECT CONVERT(varchar, CONVERT(date, '20140415'), 106)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)