Home » RDBMS Server » Server Administration » return day of the week
return day of the week [message #373842] Tue, 15 May 2001 11:50 Go to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
hi

i am trying to return the day of the week from a date in the mm/dd/yyyy format.
is there a function in oracle to do this ??
thanks in advance

Report message to a moderator

Re: return day of the week [message #373845 is a reply to message #373842] Tue, 15 May 2001 12:33 Go to previous message
Robert
Messages: 43
Registered: August 2000
Member
the day of the week
SELECT TO_CHAR(sysdate,'day') FROM dual;

the position
SELECT TO_NUMBER(TO_CHAR(TO_DATE('1999-03-31','yyyy-mm-dd'),'d') ) FROM dual;

good day

Report message to a moderator

Previous Topic: Index not use???
Next Topic: OCP developer. test ...please reply........
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 17:09:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.