
Change the Output Format of a Date with TO_DATE
If you’re working with DATE fields in Oracle, and select this data, you’ll see the dates in the default output format. Depending on your location, the default date format could be DD-MON-YYYY or something similar. If you want to display dates in a different format, use the Oracle TO_DATE function.