Home » Developer & Programmer » Forms » conversion
conversion [message #267652] Fri, 14 September 2007 02:07 Go to next message
conversing
Messages: 15
Registered: April 2006
Location: pakistan
Junior Member
can any body help me to convert currency digits into words
for example how can i convert 1000 to one thousand


regards

asif iqbal
Re: conversion [message #267658 is a reply to message #267652] Fri, 14 September 2007 02:20 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This might be one way to do that:
SQL> select to_char(to_date(1234, 'j'), 'jsp') num_to_words from dual;

NUM_TO_WORDS
------------------------------------
one thousand two hundred thirty-four
Previous Topic: A strange problem....
Next Topic: Want to import some tables from Oracle to SQL Server
Goto Forum:
  


Current Time: Thu Dec 08 10:18:42 CST 2016

Total time taken to generate the page: 0.15027 seconds