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.238. Simple example
Get name of current month.
SQL> select monthname(now()); callret VARCHAR _______________________________________________________________________________ October