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