Oracle-numtodsinterval&numtoyminterval，instrument
select sysdate now, sysdate+numtodsinterval(1,'second') add1second, sysdate+numtodsinterval(1,'minute') add1minute, sysdate+numtodsinterval(1,'hour') add1hour, sysdate+numtodsinterval(1,'day') add1day, sysdate+numtoyminterval(1,'month') add1month, sysdate+numtoyminterval(1,'year') add1year, sysdate+numtodsinterval(-1,'second') subtract1second, sysdate+numtodsinterval(-1,'minute') subtract1minute, sysdate+numtodsinterval(-1,'hour') subtract1hour, sysdate+numtodsinterval(-1,'day') subtract1day, sysdate+numtoyminterval(-1,'month') subtract1month, sysdate+numtoyminterval(-1,'year') subtract1year from dual
本站文章为和通数据库网友分享或者投稿，欢迎任何形式的转载，但请务必注明出处.
同时文章内容如有侵犯了您的权益，请联系QQ：970679559，我们会在尽快处理。