Skip to main content

MONTH function

Returns the month of the year a specific date falls in, in numeric format.

Syntax

month(<date>)
ParameterTypeDescription
datetimestampThe date from which to extract the month. Must be an expression returning a timestamp type, or a reference to a date column.

Usages

month(`created_at`)
month(date_value(`processed_at`))