Subtarcting seconds from a time

• itmasterw 60042

  SSCrazy

  Points: 2852

  More actions

  May 14, 2019 at 4:24 pm

  #3641980

  Hi,

  I have a time datatype column (Time(4)).

  I want to subtract 52 secs from it.

  This is in a computed column like this:

  (case when [Duration]<'00:52' then '00:00' else [Duration] end)

  This does not work.

  For example, one column has 00:01:16.0000 which is 1 minute and 16 seconds, or 60+16 which is 76 seconds. I want to subtract 52 from this.

  tried using dateadd() but am doing something wrong.

  any Ideas?

  Thank you

• ScottPletcher

  SSC Guru

  Points: 100262

  More actions

  May 14, 2019 at 5:03 pm

  #3642004

  Oops.  I didn't subtract from the final result:

  (case when [Duration]<'00:52' then '00:00' else DATEADD(SECOND, -52, [Duration]) end)

   

  SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!