SELECT ORDER_NUM,CUSTOMER_NUM,CUSTOMER_NAME,ADD_DAYS (ORDER_DATE,20) FROM CUSTOMER,ORDERS;
Oracle Express表示ADD_DAYS无效?任何想法我做错了什么?
如果你想添加N天你的日子。您可以使用加号运算符如下:
原文链接:https://www.f2er.com/oracle/205787.htmlSELECT ( SYSDATE + N ) FROM DUAL;