添加天数Oracle SQL [英] Add days Oracle SQL

问题描述

SELECT ORDER_NUM, CUSTOMER_NUM, CUSTOMER_NAME, ADD_DAYS (ORDER_DATE, 20)
FROM CUSTOMER, ORDERS; 

Oracle Express说ADD_DAYS无效吗?有什么想法我做错了吗?

Oracle Express says ADD_DAYS invalid? Any ideas what Am I doing wrong?

推荐答案

如果您要添加N天.您可以按如下方式使用加号运算符-

If you want to add N days to your days. You can use the plus operator as follows -

SELECT ( SYSDATE + N ) FROM DUAL;

这篇关于添加天数Oracle SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！