Results 1 to 2 of 2

Thread: dateformat

  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: dateformat

    Hi every body
    I am using a stored procedure to insert values into a table which contain a date datatype. I pass the date in MM-DD-YYYY format.
    When i execute the querry it shows error invalid month.

    create or replace procedure sample_I
    (
    P_no varchar2,
    P_date date
    )
    as
    begin
    insert into sample values(P_no ,to_date(P_date,'MM-DD-YYYY' ));
    end;

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Since p_date already is a date, you should not apply the TO_DATE function to it - doing so is the cause of your problem. Code should be:
    Code:
    create or replace procedure sample_I
    (
    P_no varchar2,
    P_date date
    )
    as
    begin
    insert into sample values(P_no ,P_date);
    end;
    BTW, since this question is Oracle-specific, it would have got answered quicker if you had posted it in the Oracle forum!

Posting Permissions

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