Multiple choice technology databases

Which statement would change the default date format to a specified format for the current session?

  1. ALTER SESSION SET NEW_DATE_FORMAT = <date_format>

  2. ALTER SESSION SET CUR_DATE_FORMAT = <date_format>

  3. ALTER SESSION SET NLS_DATE_FORMAT = <date_format>

  4. ALTER SESSION SET SESS_DATE_FORMAT = <date_format>
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ALTER SESSION SET NLS_DATE_FORMAT changes the date format for the current session only. NLS (National Language Support) parameters control locale-specific formatting. The format string uses codes like 'DD-MON-YYYY' or 'MM/DD/YYYY'. This affects how dates are displayed and converted, not how they're stored.

Keep practicing — related questions