使用INTERVAL数据类型
SQL> SELECT extract(DAY FROM delta) days,
2 extract(hour FROM delta) hours,
3 extract(minute FROM delta) minutes
4 FROM (SELECT to_timestamp('2004-10-6 12:22:01', 'YYYY-MM-DD HH24:MI:sS') -
5 to_timestamp('2004-10-1 17:48:31', 'YYYY-MM-DD HH24:MI:sS') AS delta
6 FROM dual);
DAYS HOURS MINUTES
---------- ---------- ----------
4 18 33
SQL> SELECT extract(DAY FROM delta) days,
2 extract(hour FROM delta) hours,
3 extract(minute FROM delta) minutes
4 FROM (SELECT to_timestamp('2004-10-6 12:22:01', 'YYYY-MM-DD HH24:MI:sS') -
5 to_timestamp('2004-10-1 17:48:31', 'YYYY-MM-DD HH24:MI:sS') AS delta
6 FROM dual);
DAYS HOURS MINUTES
---------- ---------- ----------
4 18 33
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/77580/viewspace-212763/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
