Home Forums SQL Server 2008 SQL Server 2008 - General how to combine and convert two integer columns to datetime RE: how to combine and convert two integer columns to datetime

  • March 15, 2013 at 3:22 pm

    #1597722

    Or, another possibility (with no character conversions/manipulation):

    SELECT

    ColA, ColB,

    DATEADD(SECOND, ColB % 100, DATEADD(MINUTE, ColB % 10000 / 100, DATEADD(HOUR, ColB / 10000,

    DATEADD(DAY, ColA % 100 - 1, DATEADD(MONTH, ColA % 10000 / 100 - 1, DATEADD(YEAR, ColA / 10000 - 1900, 0)))))) AS Col_New

    FROM (

    SELECT 20130314 AS ColA, 123011 AS ColB UNION ALL

    SELECT 20130314, 093015

    ) AS test_data

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.