sign()函数根据某个值是0、正数还是负数,分别返回0、1、-1
DECODE(SIGN(TO_DATE(TO_CHAR(D_ENDTIME,'DD/MM/YYYY'),'DD/MM/YYYY')-TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'),'DD/MM/YYYY')),0,'Y','1','Y','N') isEdit
sign()函数根据某个值是0、正数还是负数,分别返回0、1、-1
DECODE(SIGN(TO_DATE(TO_CHAR(D_ENDTIME,'DD/MM/YYYY'),'DD/MM/YYYY')-TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'),'DD/MM/YYYY')),0,'Y','1','Y','N') isEdit