Name
monthname — get name of month from a datetime
Synopsis
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
Example 24.221. Simple example
Get name of current month.
SQL> select monthname(now()); callret VARCHAR _______________________________________________________________________________ October