1 of 1

DATETIME

This page describes the DATETIME function in Lenses SQL.

DATETIME ()

Provides the current ISO date and time.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT DATETIME() 
FROM sea-vessel-position-reports
LIMIT 1;

Output:

{
  "value": {
    "DATETIME": "2023-11-29T16:30:41.146Z"
  }
}

This page describes the DATETIME function in Lenses SQL.

DATETIME ()

Provides the current ISO date and time.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT DATETIME() 
FROM sea-vessel-position-reports
LIMIT 1;

Output:

{
  "value": {
    "DATETIME": "2023-11-29T16:30:41.146Z"
  }
}