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