hai every body,

to_char(sysdate, 'd') returns the day of week like 1 thru 7 for sundays thru saturday. Here the first day of week is Sunday i.e., 1 -> sunday. But in my application first day of week is Monday. Is it possible to change the first day of week in oracle so that to_char(sysdate, 'd') still returns the day of week from 1 thru 7 for Monday thru Sunday. i.e., 1 -> Monday.

Thanking you in advance,


Regards
Issac