Re: to_char(sysdate, 'D') - number of the day [message #18577] |
Wed, 06 February 2002 03:59 |
Chris Freel
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
I have the same problem, different users have different values of NLS_TERRITORY but I want the same code to give the same results for all users.
The previous solution DOES NOT work. For some users TO_CHAR(SYSDATE,'DY') gives "SUN", "MON", "TUE", "WED" etc.
and for others "SO", "MO", DI", "MI" etc.
or "DI" "LU" "MA" "ME" etc.
depending on their language setting.
The only solution I can come up with is to use Julian day No. and MOD(), i.e.:
MOD(TO_NUMBER(TO_CHAR(SYSDATE,'J')),7)+1
but that is excessive, surely there is a better way?
|
|
|