Home » Developer & Programmer » Forms » conversion
conversion [message #267652] Fri, 14 September 2007 02:07 Go to next message
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


asif iqbal
Re: conversion [message #267658 is a reply to message #267652] Fri, 14 September 2007 02:20 Go to previous message
Messages: 21123
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;

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: Mon Jun 26 14:19:34 CDT 2017

Total time taken to generate the page: 0.10116 seconds