oracle之Trunc、round

--round(number,digits)
--number必需，要四舍五入的数字
--digits必需，位数，根据位数对number进行四舍五入
--digits = 0 四舍五入取整
select round(45.55, 0) from dual;
select round(45.35, 0) from dual;
select round(45,0) from dual;
--digits > 0 小数位四舍五入取整
select round(45.55, 1) from dual;
select round(45.35, 1) from dual;
select round(45,1) from dual;
--digits < 0 整数位取整
select round(45.55, -1) from dual;
select round(45.35, -1) from dual;
select round(45,-1) from dual;
--trunc(number,digits)
--number必需，需要截取的数字或日期
--digits，默认值为0，根据位数截取number，并不是四舍五入
select trunc(45.77,0) from dual;
select trunc(45.77,1) from dual;
select trunc(45.77,-1) from dual;
--digits='mi'，mi位后的数字用0替换
select trunc(to_date('25-11-2012 22:22:33','dd-MM-yyyy hh24:mi:ss'),'mi') from dual;
--digits缺省，number取日期不取时间
select trunc(to_date('25-11-2012 22:01:00','dd-MM-yyyy hh24:mi:ss')) from dual;
--digits='y'或'yyyy'，取日期，yyyy后面的月份和日期默认取1
select trunc(to_date('25-11-2012 22:01:00','dd-MM-yyyy hh24:mi:ss'), 'y') from dual;
--digits='mm'，取日期，mm后面的日期取默认值1
select trunc(to_date('25-11-2012 22:01:00','dd-MM-yyyy hh24:mi:ss'), 'mm') from dual;
--digits='dd'等价于digits缺省值
select trunc(to_date('25-11-2012 22:01:00','dd-MM-yyyy hh24:mi:ss'), 'dd') from dual;
--digits='hh' hh位后的mi和ss取默认值00
select trunc(to_date('25-11-2012 22:01:00','dd-MM-yyyy hh24:mi:ss'), 'hh') from dual;