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

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.

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.