monthname
get name of month from a datetime
monthname
(in dt datetime);
Description
monthname takes a datetime and returns
a string containing name of the month represented by the datetime
Parameters
dt –
A datetime.
Return Values
A VARCHAR containing name of the month.
Examples
Simple example
Get name of current month.
SQL> select monthname(now());
callret
VARCHAR
_______________________________________________________________________________
October
See Also
dayname,
dayofmonth,
dayofmonth,
dayofweek,
dayofyear,
quarter,
week,
month,
year,
hour,
minute,
second,
timezone