Home » SQL & PL/SQL » SQL & PL/SQL » Oracle query for date of the week
Oracle query for date of the week [message #247661] Tue, 26 June 2007 13:18 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: Oracle query for date of the week [message #247717 is a reply to message #247665] Wed, 27 June 2007 00:07 Go to previous message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
may be like that

select to_char(sysdate,'day') from dual


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


Current Time: Fri Dec 09 15:52:48 CST 2016

Total time taken to generate the page: 0.18146 seconds