SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

converting numbers to words

599017Nov 25 2007 — edited Nov 26 2007

hai all,

I am trying to convert an amount value in numbers to words using
to_char(to_date(salary,'j'),'jsp'). When applied to salary this is working fine. When i try with another column 'sum(extended_amount) ' this is showing error like
ORA-01854: julian date must be between 1 and 5373484

can anyone help me in this.

Thanks ans regards,
hari

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2007

Added on Nov 25 2007

8 comments

578 views