Home » SQL & PL/SQL » SQL & PL/SQL » Day of week
Day of week [message #35655] Thu, 04 October 2001 05:12 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: Re: ORA-01041 internal error.
Next Topic: how do i insert the value like 232322.456 through sql loader
Goto Forum:
  


Current Time: Sat Sep 18 04:37:05 CDT 2021