Oracle中to_char函数的用法

数字

to_char(1210.73, '9999.9') would return '1210.7' 
to_char(1210.73, '9,999.99') would return '1,210.73' 
to_char(1210.73, '$9,999.00') would return '$1,210.73' 
to_char(21, '000099') would return '000021' 

日期的用法

to_char(sysdate, 'yyyy/mm/dd'); would return '2003/07/09' 
to_char(sysdate, 'Month DD, YYYY'); would return 'July 09, 2003' 
to_char(sysdate, 'FMMonth DD, YYYY'); would return 'July 9, 2003' 
to_char(sysdate, 'MON DDth, YYYY'); would return 'JUL 09TH, 2003' 
to_char(sysdate, 'FMMON DDth, YYYY'); would return 'JUL 9TH, 2003' 
to_char(sysdate, 'FMMon ddth, YYYY'); would return 'Jul 9th, 2003' 

评论

1 楼 shutaodream 2011-11-09  

，不错，学习