NLS Parameters - Numeric to Words in Spanish
I'm working on a Border/Baja project where we are required to spell out the dollar amounts... I'm using the sql statement
select to_char(to_date(1243,'j'), 'jsp') from dual
TO_CHAR(TO_DATE(1243,'J'),'JSP')
------------------------------------
one thousand two hundred forty-three
Which works great in English...
However, they are requiring us to spell it out in Spanish on our invoices. Is there a way to do this easily changing a NLS parameter?
I basically need to convert that result to...
mil doscientos cuarenta y tres
Any advice would be great,
Thanks,
Chris