MONTH

Returns the month portion of the specified date as an integer.

Behavior type

• Immutable if thespecified date is a TIMESTAMP, DATE, VARCHAR or INTERVAL

• Stable if the specified date is aTIMESTAMPTZ

Syntax

MONTH ( date )

Parameters

date

The date to process, one of the following data types:

• VARCHAR
• DATE
• TIMESTAMP
• TIMESTAMPTZ

• INTERVAL

Examples

In the following examples, Vertica returns the month portion of the specified string. For example, '6-9' represent September 6.

=> SELECT MONTH('6-9');
 MONTH
-------
     9
(1 row)
=> SELECT MONTH (TIMESTAMP 'sep 22, 2011 12:34');
 MONTH
-------
     9
(1 row)
=> SELECT MONTH(INTERVAL '2-35' year to month);
 MONTH
-------
    11
(1 row)