Home » SQL & PL/SQL » SQL & PL/SQL » Get weekday name in PL/SQL
Get weekday name in PL/SQL [message #220909] Thu, 22 February 2007 12:55 Go to next message
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
Re: Get weekday name in PL/SQL [message #220910 is a reply to message #220909] Thu, 22 February 2007 13:00 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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 Go to previous messageGo to next message
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
Re: Get weekday name in PL/SQL [message #220936 is a reply to message #220916] Thu, 22 February 2007 15:29 Go to previous message
jprose
Messages: 3
Registered: February 2007
Junior Member
Thanks for the polite and helpful reply IT Guru!
Previous Topic: how can I get sequence's current value
Next Topic: Year Wise, Month Wise Sum of Qty Report !!
Goto Forum:
  


Current Time: Thu Dec 08 12:07:17 CST 2016

Total time taken to generate the page: 0.08907 seconds