Home » Developer & Programmer » Forms » Converting NUMBER To WORD
Converting NUMBER To WORD [message #80728] Fri, 08 November 2002 23:11 Go to next message
Qavi
Messages: 24
Registered: August 2002
Junior Member
hello Gurus !

i'm using SELECT TO_CHAR(TO_DATE(1439,'J'),'JSP') "WORD" FROM DUAL to convert it to word and its perfect when my input is in decimal its giving error
example : SELECT TO_CHAR(TO_DATE(1439.45,'J'),'JSP') "WORD" FROM DUAL

any suggestions
Rgds
Qavi

Report message to a moderator

Re: Converting NUMBER To WORD [message #80732 is a reply to message #80728] Mon, 11 November 2002 01:36 Go to previous message
steph
Messages: 15
Registered: July 2002
Junior Member
You can try

SELECT TO_CHAR(TO_DATE(ROUND(1439.45),'J'),'JSP')
"WORD" FROM DUAL

Report message to a moderator

Previous Topic: ENTER-QUERY problem
Next Topic: Migration from forms4.5 to forms6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:30:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.