1 of 1

MONTH

This page describes the MONTH function in Lenses SQL.

MONTH(dataExpr)

Builds a timestamp-millis value from a long or int value.

Available in:

Processors

SQL Studio

✓

Sample code:

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

Output:

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