Functions/Dates & time/month
Dates & time Scalar

month()

Extract the month component from a date or timestamp

Arguments & returns

4 overloads

month(ts)

Scalar
Overload link ts Returns
#01 DATE BIGINT
#02 INTERVAL BIGINT
#03 TIMESTAMP BIGINT
#04 TIMESTAMP WITH TIME ZONE BIGINT

Example

month example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Apache Sparkmonth()

MONTH('2021-03-01')
In Haybarn
MONTH(CAST('2021-03-01' AS DATE))

SQLGlot example ↗