使用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博客 ” ,链接:http://blog.itpub.net/77580/viewspace-212763/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/77580/viewspace-212763/