Oracle notes

zhaozj2021-02-16  57

1. Two dates are reduced, get the number of days

Trunc (to_date ('2004-06-22 09:51:01', 'YYYY-MM-DD HH24: MI: SS') - TO_DATE ('2003-06-22 09:50:01', 'YYYY-mm -DD ​​HH24: MI: SS ')))

转载请注明原文地址:https://www.9cbs.com/read-20603.html

New Post(0)