botang 发表于 2020-9-8 21:35:41

日期和间隔：

select sysdate+1 from dual;

selectsysdate +1/24from dual;

selectadd_months(sysdate,2) from dual;

selectsysdate +interval '10-2' year to month   from dual;

selectsysdate +interval '100-2' year(3) to month   from dual;

页: [1]
查看完整版本: 日期和间隔：