Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to change first day of the week?

ronald_20175 days ago

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 5 days ago
9 comments
105 views