Hi Friends !!if value=125000 then print the value as one lakh twenty fivethousands if I use ...to_char(to_date(sal,'jsp'),'jsp') its displaying"one hundred twenty-five thousand" I need "One Lakh Twenty-five thousand" how can i have it?Thanks in Advise..Ramki,TCS,Dp,Hyd9989018508

  • Interview Candidate
  • 2
  • 1705

Showing Answers 1 - 2 of 2 Answers

satya

  • Sep 6th, 2006
 

I think it is correct , there is no word called Lakh in US English. Try switch to language UK english then it may work.    Lot of people in USA dont understand certain UK english words.

  Was this answer useful?  Yes

developer

  • Sep 11th, 2006
 

Hi,

The correct answer is

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

try this one. hope this will help u.

bye

devp2.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions