1)TO_CHAR(number,'format_mode')
9 -->Represents a number 数字转字符显示
0 --> Forces a zero to be displayed 如果是空或者是零强制显示
. -->Prints a decimal point 小数点
, --> Prints a comma as a thousands indicator 原样输出
FM(fm) -> 去掉空格或者小数点后的占位0(如果是9格式化的去掉,0格式化的不去掉
比如:
SELECT to_char(123,'fm9990.000') FROM dual; -- 123.000
SELECT to_char(123,'fm9990.999') FROM dual; -- 123
SELECT to_char(123,'9990.000') FROM dual; -- 123.000
SELECT to_char(123,'9990.999') FROM dual; -- 123.000
2)TO_CHAR(date,'format')
其中format可以为'YYYY-MM-DD hh24:mi:ssxff' 分别代表年月日 时分秒毫秒
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ssxff') time1
from dual;
select to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff') time1
from dual;
select to_char(sysdate,'yyyy-mm-dd hh24:mi') time1
from dual;