Hi,
I need to run a stored procedure which accepts date as an input. If I input date say 11252000 (MMDDYYYY), it is accepting but for dates such as 03062000, it is throwing error "ORA-01843: not a valid month". Please help me out. In the procedure, I am using to_date to convert the date into MMDDYYYY format, but its not working for all cases. Also if someone gives a date such as 0622000 (June 2nd 2000) or 5112000 (May 11th 2000), how to handle these? Any helping hand would be appreciated.
Thanks,
deep