Name
dayname , monthname , dayofmonth , dayofweek , dayofyear , quarter , week , month , year , hour , minute , second , timezone — decompose a datetime to its components
Synopsis
dayname
(
|
in
dt
datetime
); |
monthname
(
|
in
dt
datetime
); |
dayofmonth
(
|
in
dt
datetime
); |
dayofweek
(
|
in
dt
datetime
); |
dayofyear
(
|
in
dt
datetime
); |
quarter
(
|
in
dt
datetime
); |
week
(
|
in
dt
datetime
); |
month
(
|
in
dt
datetime
); |
year
(
|
in
dt
datetime
); |
hour
(
|
in
dt
datetime
); |
minute
(
|
in
dt
datetime
); |
second
(
|
in
dt
datetime
); |
timezone
(
|
in
dt
datetime
); |
Description
These functions decompose a datetime to its components. These can be used on timestamps , datetimes , dates and times , all being the same internal data type.
: dayname name of day : monthname name of month : dayofmonth day of month : dayofweek day of week : dayofyear day since start of year : quarter quarter number, : week week number : month month number, starting at 1 for January : year year : hour hour : minute minute : second second : timezone offset from UTC in minutes
Parameters
dt
A datetime value.
Return Values
monthname
and
dayname
return a varchar
. The others return an
integer
.
Examples
Example 24.82. Simple example
SQL> select dayname(stringdate('2001-03-02'));
callret
VARCHAR
_______________________________________________________________________________
Friday
1 Rows. -- 3 msec.