1 Reply Latest reply: May 26, 2011 7:27 AM by Sandeep Gandhi, Consultant RSS

    how to convert number to word in R12

    455069
      hi

      sir

      i use this
      select to_char( to_date( 85485758, 'j' ), 'Jsp' ) from dual;
      statment for convert number to word but
      this statment give me this error

      ORA-01854: julian date must be between 1 and 5373484
      01854. 00000 - "julian date must be between 1 and 5373484"
      *Cause:    An invalid Julian date was entered.
      *Action:   Enter a valid Julian date between 1 and 5373484.


      please give me idea how i convert number to word


      thank

      fahim