Hi everyone,
i am using below query to convert for this number 1224834
SELECT TO_CHAR (TO_DATE (1224834, ‘j’), ‘jsp’) FROM DUAL
its return for : one million two hundred twenty-four thousand eight hundred thirty-four
but i want result like :
Twelve Lakhs Twenty Four Thousand Eight Hundred And Thirty Four Only
And also it has range from 1 to 5373484 is we put value after 5373484,
it will throw you an error
"ORA-01854: julian date must be between 1 and 5373484"
How to achieve this?
Thanks in Advance
VARSHA
Any help would be highly appreciated..
Vinish Kapoor
Check if this works for you:
Then test it:
VARSHA
Thank you Vinish
It's working...