OraFAQ Forum: SQL & PL/SQL » Name of seven days

Home » SQL & PL/SQL » SQL & PL/SQL » Name of seven days

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

Name of seven days [message #19811]

Wed, 10 April 2002 21:25

Gopal Raw
Messages: 19
Registered: January 2002

Junior Member

How can I get then name of seven days in one sql.

Report message to a moderator

Re: Name of seven days [message #19823 is a reply to message #19811]

Thu, 11 April 2002 06:01

Jon
Messages: 483
Registered: May 2001

Senior Member

I'm not sure what you're getting at. This would do what you're asking:

SELECT 'SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY' FROM DUAL;

If you're after something different, please be specific.

Report message to a moderator

Re: Name of seven days [message #19825 is a reply to message #19811]

Thu, 11 April 2002 07:21

Jay
Messages: 127
Registered: October 1999

Senior Member

I guess this is what you are looking for:
SELECT sysdate,TO_CHAR(sysdate,'DAY')day
FROM dual;

SYSDATE DAY
--------- ---------
11-APR-02 THURSDAY

SELECT hiredate,TO_CHAR(hiredate,'DAY')"DAY"
FROM emp
WHERE empno=7839;

HIREDATE DAY
--------- ---------
17-NOV-81 TUESDAY

Report message to a moderator

Previous Topic:	"illegal variable name/number" error when one more OUT param along with a ref cursor
Next Topic:	Table Scripts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 15:08:49 CDT 2024