oracle 做算法 数据为空时,默认为0
摘要:SELECT NVL('',0) FROM DUAL获取当前日期: SELECT SYSDATE FROM DUAL当前日期-某个日期差的天数 SELECT TO_NUMBER(SYSDATE - TO_DATE('2015-02-01 00:00:00', 'yyyy-mm-dd hh24:mi:...
阅读全文
posted @ 2015-02-11 17:21
posted @ 2015-02-11 17:21
posted @ 2015-02-11 17:13
posted @ 2015-02-11 17:08