OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » weekdays

Fri, 22 February 2002 07:24

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

Fri, 22 February 2002 10:17

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: Sat Apr 20 07:47:55 CDT 2024