Topic: 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')