OraFAQ Forum: Server Administration » how To convert number say '34' to 'thirty four' ?

Home » RDBMS Server » Server Administration » how To convert number say '34' to 'thirty four' ?

Sat, 03 March 2001 06:47

Pravin Deshmukh
Messages: 8
Registered: October 2000

Junior Member

I have read about it some where,but could'nt remeber it(something like using to_date and 'J' format).
Pl. help and send me the script?

Sat, 03 March 2001 06:51

Balamurugan.R
Messages: 91
Registered: March 2001

Member

hai,

select to_char(to_date(34,'j'),'jsp') from dual;

Sun, 04 March 2001 00:39

Pravin Deshmukh
Messages: 8
Registered: October 2000

Junior Member

Thanks a lot,
What 'jsp' stands for?

Tue, 06 March 2001 22:10

Pravin Deshmukh
Messages: 8
Registered: October 2000

Junior Member

How do I read the numbers after decimal?

Previous Topic:	Need help on Trees query!!! Urgent!!!
Next Topic:	Re: recordcount????

Goto Forum:

]

Current Time: Sat Jun 29 01:15:56 CDT 2024