TO_CHAR(SYSDATE,'d') shows 3 for some and 4 for others (on a Wednesday)

dgs!

Member³
When I execute SELECT TO_CHAR(SYSDATE,'d') FROM DUAL;
(on a Wednesday), I get '3', but my co-workers get a '4'.
We have concluded that my NLS_TERRITORY is different.
It seems that it has been set somewhere within PL/SQL Developer.
Where is this setting?
How do I change it?

Thanks
 
The NLS_TERRITORY is set in the Oracle Registry, and is controlled by the NLS_LANG key (LANGUAGE_TERRITORY.CHARSET).
 
Marco, you were right on!!
Everyone else in my group had that set to AMERICAN_AMERICA.WE8MSWIN1252.
For some reason, mine was set to: ENGLISH_UNITED KINGDOM.WE8MSWIN1252.

On Wednesday I executed this:
select to_char(sysdate,'d') from dual;

I got 3, everyone else in my group got 4.

Thanks for your help!
 
Last edited:
Back
Top