Home Forums SQL Server 2008 T-SQL (SS2K8) Adding Seconds to Time field RE: Adding Seconds to Time field

  • August 30, 2012 at 11:53 am

    #1532048

    Jeff Moden (8/30/2012)

    celayne (8/29/2012)

    It is a time field

    Then you actually have a potentially serious problem. What do you want to do when adding the seconds takes you over 24 hours???

    Doesn't overflow, just rolls around.

    declare @TimeStr time = '16:40:27',

    @SecondsAtStatus int = 86399;

    select @TimeStr, dateadd(ss, @SecondsAtStatus, @TimeStr)

    go

    declare @TimeStr time = '16:40:27',

    @SecondsAtStatus int = 86400;

    select @TimeStr, dateadd(ss, @SecondsAtStatus, @TimeStr)

    go

    declare @TimeStr time = '16:40:27',

    @SecondsAtStatus int = 86401;

    select @TimeStr, dateadd(ss, @SecondsAtStatus, @TimeStr)

    go