1 of 1

MONTH_TEXT

This page describes the MONTH_TEXT function in Lenses SQL.

MONTH_TEXT(dataExpr)

Returns the month name.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    MONTH_TEXT(_meta.timestamp), 
    _meta.timestamp 
FROM sea-vessel-position-reports
LIMIT 1;

Output:

{
  "value": {
    "MONTH_TEXT": "November",
    "timestamp": "2023-11-28T20:28:45.337Z"
  }
}

This page describes the MONTH_TEXT function in Lenses SQL.

MONTH_TEXT(dataExpr)

Returns the month name.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    MONTH_TEXT(_meta.timestamp), 
    _meta.timestamp 
FROM sea-vessel-position-reports
LIMIT 1;

Output:

{
  "value": {
    "MONTH_TEXT": "November",
    "timestamp": "2023-11-28T20:28:45.337Z"
  }
}