1 of 1

TIME_MICROS

This page describes the TIME_MICROS function in Lenses SQL.

TIME_MICROS(micros)

Builds a time-micros value from a long or int value.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

{
  "value": {
    "TIME_MICROS": "20:47:13.67939",
    "Timestamp": "1503158676433679390"
  }
}

This page describes the TIME_MICROS function in Lenses SQL.

TIME_MICROS(micros)

Builds a time-micros value from a long or int value.

Available in:

Processors

SQL Studio

Sample code:

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

Output:

{
  "value": {
    "TIME_MICROS": "20:47:13.67939",
    "Timestamp": "1503158676433679390"
  }
}