MONTH()

MONTH() — Returns the month of the year as an integer value.

Synopsis

MONTH( timestamp-or-date )

Description

The MONTH() function returns an integer value between 1 and 12 representing the date or timestamp's month of the year. The MONTH() function produces the same result as using the MONTH keyword with the EXTRACT() function.

Examples

The following example uses the DAY(), MONTH(), and YEAR() functions to return a timestamp column as a formatted date string.

SELECT  CAST( MONTH(starttime) AS VARCHAR) || '/' || 
        CAST( DAY(starttime)   AS VARCHAR) || '/' || 
        CAST( YEAR(starttime)  AS VARCHAR), title, description 
        FROM event ORDER BY starttime;