Month

The Month function returns an integer representing the month component of a specified date and time.

Syntax

Month(date, \[timezone\])

The Month function has the following arguments:

date

Required

The date or the column that contains date values where Sigma extracts the month component

timezone

Optional

The IANA time zone; for example, (e.g., “America/Los_Angeles”, used to convert the date value before extracting the month component.

When omitted, timezone Sigma evaluates the date in UTC time.

Examples

Month(Date("2007-08-14"))

Extracts the month component from the specified date (August 14, 2007) and returns 8 to represent the eighth month of the year.

Month(Date)

The Month function returns the following values for the Date column: