MONTHNAME

​

Syntax

​

Scalar

monthname(value)

​

Arguments

​

Returns

• Type: STRING
• NULL behavior: A NULL DATE returns NULL; month values map to the three-letter English names Jan through Dec.

​

Properties

​

Usage notes

• Month names are Jan through Dec.

​

Examples

​

Basic example

SELECT monthname(DATE '2024-03-15') AS result;

​

Names at the year boundaries

SELECT monthname(DATE '2024-01-01') AS first_month, monthname(DATE '2024-12-31') AS last_month;