dayofweek
get day of week from a datetime
dayofweek
(in dt datetime);
Description
dayofweek takes a datetime and returns
an integer containing a number representing the day of week of the datetime.
Parameters
dt –
A datetime.
Return Values
An INTEGER containing number of the day of week.
Examples
Simple example
Get current day of week.
SQL> select dayofweek(now());
callret
INTEGER
_______________________________________________________________________________
6
See Also
dayname,
monthname,
dayofmonth,
dayofyear,
quarter,
week,
month,
year,
hour,
minute,
second,
timezone