Using case expression in DATEADD interval

Question

Is possible to use case expression inside of DATEADD interval parameter?

select DATEADD(case c1 when 1 then HOUR when 2 then DAY end, c2, date) from T

Update1: Sorry, I want to use it in where clause

select * from T where DATEADD(case c1 when 1 then HOUR when 2 then DAY end, c2, date) < GETDATE()

Maybe there is another alternative.

Thanks in advance,

Answer 1

Try below..

select * from T 
where case c1 when 1 then DATEADD(HOUR, c2, date) 
when 2 then DATEADD(DAY, c2, date) 
end < Getdate()