Home » SQL & PL/SQL » SQL & PL/SQL » Re: to_char(sysdate, 'D') - number of the day
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?
Previous Topic: help me!!
Next Topic: Trigger for ALTER TABLE
Goto Forum:
  


Current Time: Sat Sep 25 19:55:02 CDT 2021