OraFAQ Forum: SQL & PL/SQL » Get weekday name in PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Get weekday name in PL/SQL

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

Get weekday name in PL/SQL [message #220909]

Thu, 22 February 2007 12:55

jprose
Messages: 3
Registered: February 2007

Junior Member

Does anyone know if there is a built in PL/SQL function or another method to get the weekday name (or a number) for a date?

I'm just selecting a date and I need to know if it is a Monday, Tuesday, etc...

Thanks in advance to anyone who might have a tip on this,
JP

Report message to a moderator

Re: Get weekday name in PL/SQL [message #220910 is a reply to message #220909]

Thu, 22 February 2007 13:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

EXPERT Question?

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/functions180.htm#sthref2296

[Updated on: Thu, 22 February 2007 13:01] by Moderator

Report message to a moderator

Re: Get weekday name in PL/SQL [message #220916 is a reply to message #220909]

Thu, 22 February 2007 13:39

IT Guru
Messages: 59
Registered: January 2007

Member

SELECT TO_CHAR(SYSDATE,'Day') FROM DUAL

for getting as Monday

SELECT TO_CHAR(SYSDATE,'D') FROM DUAL

for get as 1 or 2 for monday sunday

Report message to a moderator

Re: Get weekday name in PL/SQL [message #220936 is a reply to message #220916]

Thu, 22 February 2007 15:29

jprose
Messages: 3
Registered: February 2007

Junior Member

Thanks for the polite and helpful reply IT Guru!

Report message to a moderator

Previous Topic:	how can I get sequence's current value
Next Topic:	Year Wise, Month Wise Sum of Qty Report !!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 17 14:49:02 CDT 2025