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 2:20 pm

    #1597677

    naveen.pasupuleti (3/15/2013)

    I have date stored in a column as integer type and time stored in a column as integer type. How do I combine and convert both columns into datetime type?

    For Example: Col A has 20130314 (yyyymmdd) and Col B has 123000 (hhmmss). My Output should be 2013-03-14 12:30:00

    Something like this:

    declare @TestDate int = 20130314,

    @TestTIme int = 123000;

    select cast(cast(@TestDate as varchar(8)) as datetime),

    cast(stuff(stuff(cast(@TestTime as varchar(6)),5,0,':'),3,0,':') as time(0)),

    cast(cast(@TestDate as varchar(8)) as datetime) + cast(stuff(stuff(cast(@TestTime as varchar(6)),5,0,':'),3,0,':') as time(0));