Help me in PHP- Oracle

[balasun]

Hello all,

 

I need to excute the oracle query like Below:

"begin

    myfriends_data.get_multi_rows_details(:StartDate,

                                          :EndDate,

                                          :filed3,

                                          :filed4,

                                          );

end";

 

I give the StartDate value as '01/01/2009';

 

But when i execute the query,i got the error like Below:

 

  ORA-01843: not a valid month

ORA-06512: at line 2

 

Pls help me how to solve the problem.

 

Thanks,

[roydude]

Hi Balasun,

 

This is an old topic, but I thought I'd post a reply in case someone needs it at some stage.

 

At a guess I'd say you need to use a date format mask around the date you're supplying -

 

  to_date('21/02/2009', 'DD/MM/YYYY')