MONTH

Purpose

This function returns the month of a date.

Syntax

month::=

Usage Notes

  • This function can also be applied on strings, in contrast to function EXTRACT.
  • For data type TIMESTAMP WITH LOCAL TIME ZONE this function is calculated within the session time zone.

Example

Copy 
SELECT MONTH(DATE '2010-10-20');