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