在Oraclez中这个sql怎么写的啊～

[saintqiqi]

SELECT CASE WHEN
DATEDIFF(day,dateadd(day,15,LendDate),getdate()) >=0 THEN '../image/lendstate1.gif'
WHEN
datediff(day,dateadd(day,30,LendDate),getdate()) >=0 THEN '../image/lendstate2.gif' ELSE '../image/lendstate1.gif'
END AS LendStatus FROM EquipLendNote e;

[UandM]

SELECT CASE WHEN trunc(sysdate-LendDate-15)>0
THEN '../image/lendstate1.gif'
WHEN trunc(sysdate-LendDate-30)>0
THEN '../image/lendstate2.gif'
ELSE '../image/lendstate1.gif'
END AS LendStatus FROM EquipLendNote e;

[UandM]

其实直接翻译应该是
SELECT CASE WHEN trunc(sysdate-(LendDate+15))>0 THEN '../image/lendstate1.gif'
WHEN trunc(sysdate-(LendDate+30))>0 THEN '../image/lendstate2.gif' ELSE '../image/lendstate1.gif'
END AS LendStatus FROM EquipLendNote e;