To make life even more confusing I'm getting different results with different versions of SQL Plus on the same PC! When running a 8.1.7 sSQL Plus I get 4 and when running a 8.0.6 from a different ORACLE_HOME I get 5. THe server version is 184.108.40.206.
I was thinking it could be an NLS problem i.e. some regions start the week on a Sunday and others on a Monday but I'm not aware of any NLS parameters in the sqlnet.ora file.
Any help would be much appreciated!
True. In some parts of our world people have a habit to start counting the days of the week begining on Sundays, while on other parts week starts om Monday.... So it is NLS_TERRITORY dependant, not computer dependant. On the same computer you can have two oracle homes with different NLS settings, hence you can get different results from the same query if the tools used are from different oracle_homes.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?