Question: how to change date format in oracle to mm/dd/yyyy?
Answer: Select Preferences in the left frame, or select File, and then Preferences.
Click the Planning icon, and then select Display Options.
For Date Format, select MM-DD-YYYY, DD-MM-YYYY, YYYY-MM-DD, or Automatically Detect (to use your system's locale settings).
Click OK.