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