Обсуждение: Number to Words Conversion
Hello Frnds, Is there any way to Convert the Number to its equivalent String ( Words) e.g. 10 to TEN. Urgent require the Answer.. Regards, Yogesh Arora
yogesh wrote: > Hello Frnds, > > Is there any way to Convert the Number to its equivalent String > ( Words) > > e.g. 10 to TEN. Urgent require the Answer.. (column sizes just an example) CREATE TABLE integer_string ( number SMALLINT NOT NULL, word VARCHAR(24) NOT NULL ); brian
yogesh wrote: > Hello Frnds, > > Is there any way to Convert the Number to its equivalent String > ( Words) > > e.g. 10 to TEN. Urgent require the Answer.. We have cash_words: test=> SELECT cash_words('100'); cash_words ------------------------------------ One hundred dollars and zero cents (1 row) but that is money-oriented. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Hi,
You can use what bruce has suggested and get the value you want.
eg.
select trim(substring(cash_words('1520'), 1, position('dollars' in cash_words('1520'))-1));
will return you
One thousand five hundred twenty (But ofcourse this eg. does not work for decimals)
Regards,
Moiz Kothari
--
Hobby Site : http://dailyhealthtips.blogspot.com
You can use what bruce has suggested and get the value you want.
eg.
select trim(substring(cash_words('1520'), 1, position('dollars' in cash_words('1520'))-1));
will return you
One thousand five hundred twenty (But ofcourse this eg. does not work for decimals)
Regards,
Moiz Kothari
On 11/2/07, Bruce Momjian < bruce@momjian.us> wrote:
yogesh wrote:
> Hello Frnds,
>
> Is there any way to Convert the Number to its equivalent String
> ( Words)
>
> e.g. 10 to TEN. Urgent require the Answer..
We have cash_words:
test=> SELECT cash_words('100');
cash_words
------------------------------------
One hundred dollars and zero cents
(1 row)
but that is money-oriented.
--
Bruce Momjian < bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
--
Hobby Site : http://dailyhealthtips.blogspot.com
Hi,
So how would it look like if you say "1520.50" what should it return you back?
Regards,
Moiz Kothari
--
Hobby Site : http://dailyhealthtips.blogspot.com
So how would it look like if you say "1520.50" what should it return you back?
Regards,
Moiz Kothari
On 11/2/07, Yogesh Arora <yogesh.arora.daffodil@gmail.com> wrote:
Hi,
As i am Working for Decimal Formats..... is there any method to do it in the same way.--On 11/2/07, Moiz Kothari < moizpostgres@gmail.com> wrote:Hi,
You can use what bruce has suggested and get the value you want.
eg.
select trim(substring(cash_words('1520'), 1, position('dollars' in cash_words('1520'))-1));
will return you
One thousand five hundred twenty (But ofcourse this eg. does not work for decimals)
Regards,
Moiz KothariOn 11/2/07, Bruce Momjian < bruce@momjian.us> wrote:yogesh wrote:---------------------------(end of broadcast)---------------------------
> Hello Frnds,
>
> Is there any way to Convert the Number to its equivalent String
> ( Words)
>
> e.g. 10 to TEN. Urgent require the Answer..
We have cash_words:
test=> SELECT cash_words('100');
cash_words
------------------------------------
One hundred dollars and zero cents
(1 row)
but that is money-oriented.
--
Bruce Momjian < bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
TIP 5: don't forget to increase your free space map settings
--
Hobby Site : http://dailyhealthtips.blogspot.com
Best Regards,
Yogesh Arora
--
Hobby Site : http://dailyhealthtips.blogspot.com
Hi,
As i am Working for Decimal Formats..... is there any method to do it in the same way.
--
Best Regards,
Yogesh Arora
As i am Working for Decimal Formats..... is there any method to do it in the same way.
On 11/2/07, Moiz Kothari < moizpostgres@gmail.com> wrote:
Hi,
You can use what bruce has suggested and get the value you want.
eg.
select trim(substring(cash_words('1520'), 1, position('dollars' in cash_words('1520'))-1));
will return you
One thousand five hundred twenty (But ofcourse this eg. does not work for decimals)
Regards,
Moiz KothariOn 11/2/07, Bruce Momjian < bruce@momjian.us> wrote:yogesh wrote:---------------------------(end of broadcast)---------------------------
> Hello Frnds,
>
> Is there any way to Convert the Number to its equivalent String
> ( Words)
>
> e.g. 10 to TEN. Urgent require the Answer..
We have cash_words:
test=> SELECT cash_words('100');
cash_words
------------------------------------
One hundred dollars and zero cents
(1 row)
but that is money-oriented.
--
Bruce Momjian < bruce@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
TIP 5: don't forget to increase your free space map settings
--
Hobby Site : http://dailyhealthtips.blogspot.com
--
Best Regards,
Yogesh Arora