Home » SQL & PL/SQL » SQL & PL/SQL » Day Of Week Isolation
Day Of Week Isolation [message #35851] Fri, 19 October 2001 07:32 Go to next message
Craig
Messages: 28
Registered: October 2001
Junior Member
Is there a function that isolates the day of the week?

Eg. DB2 has a DAYOFWEEK function.

Many thanks for any help

Craig

----------------------------------------------------------------------
Re: Day Of Week Isolation [message #35854 is a reply to message #35851] Fri, 19 October 2001 07:57 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select to_char(sysdate,'d') from dual;

----------------------------------------------------------------------
Previous Topic: wait for database entry in pl/sql
Next Topic: Re: how to find the top 5 biggest value from a query
Goto Forum:
  


Current Time: Thu Mar 28 21:00:04 CDT 2024