NUMTODSINTERVAL

最近更新时间: 2025-02-18 16:02: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=#