Home » SQL & PL/SQL » SQL & PL/SQL » weekdays
weekdays [message #37708] Fri, 22 February 2002 07:24 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
hi guys,

Is there anyway to identify what day of the week.
If the input comes in as 1 or 2 or 3

Thanks in advance
Re: weekdays [message #37711 is a reply to message #37708] Fri, 22 February 2002 10:17 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select to_char(sysdate-to_number(to_char(sysdate,'d'))+&num,'day') from dual;

-- num must be 1 to 7
Previous Topic: Exponential and Log functions?
Next Topic: I got two errors when I start the PL/SQL plus for the first time.
Goto Forum:
  


Current Time: Mon Sep 27 18:07:07 CDT 2021