Name
dayofweek — get day of week from a datetime
Synopsis
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
Example 24.84. Simple example
Get current day of week.
SQL> select dayofweek(now()); callret INTEGER _______________________________________________________________________________ 6