Question: how to set date format in stored procedure in oracle?
Answer: Using an ANSI literal BEGIN test_proc( DATE '2018-01-01' ); END;
Or by specifying the format mask used in the conversion BEGIN test_proc( TO_DATE( '01/01/2018', 'MM/DD/YYYY' ) ); END;