Skip to Main Content

SQL & PL/SQL

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!

How to change first day of the week?

ronald_2017Mar 24 2025

Hello All,

I use Oracle 19, how to set first week day as monday in database level? Not session level.

ALTER SESSION SET NLS_TERRITORY = TURKEY;
SQL> select to_char(sysdate, 'D'), to_char(sysdate, 'DAY') from dual;

T TO_CHAR(SYSDATE,'DAY')
- ------------------------------------
2 MONDAY

Thanks

This post has been answered by Solomon Yakobson on Mar 24 2025
Jump to Answer
Comments
Post Details
Added on Mar 24 2025
9 comments
318 views