NUMTODSINTERVAL

最近更新时间: 2025-10-11 18:10:00

numtodsinterval(

postgres=# select sysdate,sysdate+numtodsinterval(2,'hour') as res from dual; 
    orcl_sysdate     |         res         
---------------------+---------------------
 2020-08-02 21:55:35 | 2020-08-02 23:55:35
(1 row)
 postgres=#