OraFAQ Forum: SQL & PL/SQL » Oracle query for date of the week

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle query for date of the week

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

Oracle query for date of the week [message #247661]

Tue, 26 June 2007 13:18

mamnoon23
Messages: 1
Registered: June 2007

Junior Member

Please help me to write the following Oracle Query...
Write a query , which will return the DAY of the week(like MONDAY) for any data entered in the format : DD.MM.YY..
Please don'thelp it is NOTurgent...
Thanks in advance

[mod-edit]altered inane arrogant references to speed of answer required.

[Updated on: Tue, 26 June 2007 14:52] by Moderator

Report message to a moderator

Re: Oracle query for date of the week [message #247665 is a reply to message #247661]

Tue, 26 June 2007 13:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please help it is very urgent...
Please explain why it is urgent for ME to solve this problem for you.

use TO_DATE & TO_CHAR

Report message to a moderator

Re: Oracle query for date of the week [message #247717 is a reply to message #247665]

Wed, 27 June 2007 00:07

ammishra
Messages: 179
Registered: January 2007
Location: india

Senior Member

may be like that

select to_char(sysdate,'day') from dual

--Yash

Report message to a moderator

Previous Topic:	Partioning a Table, either List or Range without Hard coding the values
Next Topic:	order by clause in select into

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 20:24:03 CST 2024