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

  • August 29, 2012 at 11:14 am

    #1531531

    This:

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

    @SecondsAtStatus int = 734;

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