1、TO_CHAR格式化当前的时间日期
SELECT TO_CHAR(sysdate,'YYYY-MM-DD HH24:MI:SS') FROM dual;
2、TO_CHAR格式化数字显示
SELECT TO_CHAR (987654321.789,'L999,999,999,999.99999') FROM dual;
3、TO_DATE,转换成日期
SELECT TO_DATE('1989-01-01','YYYY-MM-DD') FROM dual;
4、TO_NUMBER把字符串内容变为数字型
SELECT TO_NUMBER('100')+TO_NUMBER('111') FROM dual;