-- Start
日期也能做四舍五入?是的,我们可以使用 ROUND 和 TRUNC 函数对日期四舍五入。下面是一个简单的例子。
SELECT
TIMESTAMP '2015-02-10 05:15:29.800' DATE_TIME,
ROUND(TIMESTAMP '2015-02-10 05:15:29.800', 'DD') ROUND,
TRUNC(TIMESTAMP '2015-02-10 05:15:29.800', 'DD') TRUNC
FROM DUAL
UNION ALL
SELECT
TIMESTAMP '2015-08-20 15:40:31.100' DATE_TIME,
ROUND(TIMESTAMP '2015-08-20 15:40:31.100') ROUND,
TRUNC(TIMESTAMP '2015-08-20 15:40:31.100') TRUNC
FROM DUAL;
-- 结果如下
DATE_TIME ROUND TRUNC
2015-02-10 05:15:29.800000 2015-02-10 00:00:00.000000 2015-02-10 00:00:00.000000
2015-08-20 15:40:31.100000 2015-08-21 00:00:00.000000 2015-08-20 00:00:00.000000
-- 说明
1. ROUND 和 TRUNC 函数接受两个参数&#x