Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Conversion of Date from legacy systems with 7 and 6 digit format to DD/MM/YYYY format RE: Conversion of Date from legacy systems with 7 and 6 digit format to DD/MM/YYYY format

  • November 19, 2014 at 2:24 pm

    #1759653

    SELECT CONVERT(datetime, CASE WHEN LEFT('1100323', 1) = '1' THEN '20' ELSE '19' END + RIGHT('1100323', 6), 112)

    http://msdn.microsoft.com/en-us/library/ms187928.aspx