Question: how to change date format in oracle 10g?
Answer: 2 Answers. You can use TO_CHAR to format your date. SELECT TO_CHAR(:P_1,'MM/DD/RR') from dual; for both BeginDate and EndDate .