Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Defects_1.id,
- case when Defects_1.status Not Like '4-Closed%' then (CURRENTDATE() - Defects_1.creation_time) As Defect_Age end
- case when Defects_1.status Like '4-Closed%' then Defects_1.user_11as Defect_Age end
- from Defects_1
- Order By Defects_1.id
- select Defects_1.id,
- case when Defects_1.status Not Like '4-Closed%' then (CURRENTDATE() - Defects_1.creation_time) end As Defect_Age
- case when Defects_1.status Like '4-Closed%' then Defects_1.user_11 end as Defect_Age
- from Defects_1
- Order By Defects_1.id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement