dateformat

sajusv · #1 (**permalink**) 09-30-04, 02:08

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;

andrewst · #2 (**permalink**) 10-11-04, 08:18

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!

Internet Services

Web Development

Digital Marketing

Consumer Tech