Home Forums SQL Server 2012 SQL Server 2012 - T-SQL convert date format from mmddyy to yyyy-mm-dd hh:mm:sec RE: convert date format from mmddyy to yyyy-mm-dd hh:mm:sec

  • August 31, 2015 at 3:30 am

    #1823318

    Louis Hillebrand (8/31/2015)

    If the source is always a 6 character string:

    Rearrange the input to a yymmdd string with two substrings.

    Convert to date using CONVERT using style 12 (yymmdd)

    DECLARE @D nvarchar(6) = '083115'

    SELECT CONVERT(DateTime, SUBSTRING(@D, 5, 2) + SUBSTRING(@D, 1, 4), 12)

    Louis.

    Thanks Louis for the solution.