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