OraFAQ Forum: SQL & PL/SQL » How to find day of the week, starting with Monday

Home » SQL & PL/SQL » SQL & PL/SQL » How to find day of the week, starting with Monday

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find day of the week, starting with Monday [message #607003]

Sat, 01 February 2014 03:10

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi All,
Please provide answers of my query:-
Display the last name, hire date and day of week on which the employee started, label the column day, and order the result by the day of the week, starting with Monday

Report message to a moderator

Re: How to find day of the week, starting with Monday [message #607005 is a reply to message #607003]

Sat, 01 February 2014 03:32

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

This is obviously homework. So rather than just give you the answer, which would make me complicit in your cheating, I'll point you towards the documentation that will allow you to actually learn what you need to know in order to answer this question.

Report message to a moderator

Re: How to find day of the week, starting with Monday [message #607014 is a reply to message #607005]

Sat, 01 February 2014 07:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual

http://www.oracle.com/pls/db121/search?remark=quick_search&word=to_char

Report message to a moderator

Re: How to find day of the week, starting with Monday [message #607016 is a reply to message #607014]

Sat, 01 February 2014 08:50

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Okay, give me query for:

Display the last name, hire date on which the employee started order by hire date

I will help you in finding the day of the week.

Manu

[Updated on: Sat, 01 February 2014 08:51]

Report message to a moderator

Re: How to find day of the week, starting with Monday [message #607019 is a reply to message #607016]

Sat, 01 February 2014 09:57

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No need to help him on this, the link to the documentation has already been given.

Report message to a moderator

Re: How to find day of the week, starting with Monday [message #607051 is a reply to message #607019]

Sat, 01 February 2014 14:20

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Michel Cadot wrote on Sat, 01 February 2014 15:57

No need to help him on this, the link to the documentation has already been given.

Twice

Report message to a moderator

Re: How to find day of the week, starting with Monday [message #607052 is a reply to message #607051]

Sat, 01 February 2014 14:22

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Okay, agreed.

Aaditya, I have to take my words back.

Report message to a moderator

Previous Topic:	Run Print cmd through plsql
Next Topic:	Simple Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 00:18:12 CDT 2024