Friday, October 11, 2013

Case and DateDiff error

Refer this example,



declare @field1 datetime,@field2 datetime
set @field1 = getdate()
set @field2 = getdate() - 4
Select Case
when datediff(d,@field1,@field2) > 3 then 'late'
else 'on time' end [Status]





Regards, RSingh


No comments:

Post a Comment