dayname
decompose a datetime to its components
dayname
(in dt datetime);
dayofmonth
(in dt datetime);
dayofweek
(in dt datetime);
dayofyear
(in dt datetime);
hour
(in dt datetime);
minute
(in dt datetime);
month
(in dt datetime);
monthname
(in dt datetime);
quarter
(in dt datetime);
second
(in dt datetime);
timezone
(in dt datetime);
week
(in dt datetime);
year
(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
Simple example
SQL> select dayname(stringdate('2001-03-02'));
callret
VARCHAR
_______________________________________________________________________________
Friday
1 Rows. -- 3 msec.