Oracle Database Changing How SQL/Plus or SQL Developer Display Dates


When SQL/Plus or SQL Developer display dates they will perform an implicit conversion to a string using the default date format model (see the Setting the Default Date Format Model example).

You can change how a date is displayed by changing the NLS_DATE_FORMAT parameter.