Day of week [message #35655] |
Thu, 04 October 2001 05:12 |
Craig
Messages: 28 Registered: October 2001
|
Junior Member |
|
|
Is there an oracle function that identifies the day of the week.
E.g. In DB2 it is dayofweek and the number 7 represents sunday.
Many thanks for any help.
----------------------------------------------------------------------
|
|
|
Re: Day of week [message #35656 is a reply to message #35655] |
Thu, 04 October 2001 05:20 |
Jon
Messages: 483 Registered: May 2001
|
Senior Member |
|
|
Not sure exactly what you're looking for. Is this helpful?
09:16:41 ==> select to_char(sysdate, 'Day') from dual;
TO_CHAR(S
---------
Thursday
----------------------------------------------------------------------
|
|
|
Re: Day of week [message #37430 is a reply to message #35655] |
Thu, 07 February 2002 04:57 |
Chris Freel
Messages: 2 Registered: February 2002
|
Junior Member |
|
|
See thread "to_char(sysdate,'D') - number of the day".
The problem with TO_CHAR(...,'D') is that it gives a different result depending on the user's NLS settings. Something to do with Americans starting their weeks on a different day to the rest of the world.
|
|
|