🎴 Flashcard Mode
Teradata and Oracle PL/SQL Database Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which statement would change the default date format to a specified format for the current session?
AnswerClick to flip back
A
ALTER SESSION SET NLS_DATE_FORMAT = <date_format>
💡 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.