数字转换为英文的函数
[sql] www.2cto.com
sys@ORCL> select to_char(to_date('1314','J'),'Jsp') as
"I love 1314" from dual;
I love 1314
-----------------------------------
One Thousand Three Hundred Fourteen
注释： j就是范围在1--5373484之间
算算是今年的第几天
[sql] www.2cto.com
sys@ORCL> select to_date('123','J') from dual;
TO_DATE('123','J')
------------------
03-MAY-12