Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Increment date based on the time value automatically RE: Increment date based on the time value automatically

  • July 1, 2015 at 5:43 am

    #1809435

    declare @i int,@T smallint

    select @i = 20100101

    Select @T=1900

    select dateadd(minute,@T%100,(dateadd(hour,@T/100,

    CONVERT (datetime,convert(char(8),@i))

    )))

    try this

    Edited to say that I am now confused so I am leaving initial attempt in here, but might not work anymore.

    Thought we were trying to concatenate int date and int time into a date time.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]