Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Instance level NLS date format settings

Praneeth BhogadiJun 15 2026

Is there any supported way at the instance level to ensure that the Oracle database always returns English month abbreviations (e.g., “JAN”) when using the format mask 'MON' in TO_CHAR(date, 'MON'), without using NLS_DATE_LANGUAGE in the function call?

Comments
Post Details
Added on Jun 15 2026
3 comments
75 views