MINUTE

This page describes the MINUTE function in Lenses SQL.

MINUTE(dataExpr)

Extracts the minute component of an expression that is of type timestamp.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

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

Output:

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