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 4:10 am

    #1823324

    For fun, here is an alternative

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    DECLARE @STR_DATE VARCHAR(6) = '083115';

    SELECT CONVERT(DATETIME,STUFF(STUFF(@STR_DATE,3,0,'/'),6,0,'/'),1);

    Output

    2015-08-31 00:00:00.000