,第二个参数为保留的位数,大于0的为小数点后,小于0的为小数点前的
SQL> select ROUND(45.926, 2) 一,ROUND(45.926, 1) 二, ROUND(45.926, 0)...,大于0的为小数点后,小于0的为小数点前的
SQL> select TRUNC(45.926, 2) 一,TRUNC(45.926, 1) 二, TRUNC(45.926, 0) 三,
2...char ->date ; number -> varchar2 ; date ->varchar2 ;
SQL> --显式转换
SQL> --number to_char character ;...character to_number number ; date to_char character ; char to_date date ;
SQL> select to_char(sysdate...小数点;, 千位符;
SQL> --查询员工的薪水: 货币符号,两位小数,千位符
SQL> select sal, to_char(sal,'L9,999.99') from emp;
SQL> --