Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Convertion of date to char

    Hi,

    I am trying to replace selection crieteria of a field expiration_d

    from "nvl(to_char(max(p.expiration_d),'mm/dd/yyyy'),'12/31/4712')"

    to "to_char(max(nvl(p.expiration_d,to_date

    ('12/31/4712', 'MM/DD/YYYY'))),'MM/DD/YYYY')" in my storedprocedure.

    It is giving a warning that " Procedure created with compilation errors"

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Convertion of date to char

    So type SHOW ERRORS to see what the errors are.

  3. #3
    Join Date
    Mar 2004
    Posts
    4
    What i see different in the query below is that you are trying to parse an unexistent year (4712) for the oracle database as a date. In the previous line that is always treated as a char, if you see it carefully.
    I support the recent request, ask for the show errors.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •