Name

month — get number of month from a datetime

Synopsis

month ( in dt datetime );

Description

month takes a datetime and returns an integer containing a number representing the month of year of the datetime.

Parameters

dt

A datetime .

Return Values

An INTEGER containing number of the month of year.

Examples

Example24.220.Simple example

Get current month of year.

SQL> select month (now ());
callret
INTEGER
_______________________________________________________________________________

10