Unix timestamp function

As explained in Logs and Telemetry

The unix_timestamp function returns a timestamp as a numeric Unix time value suitable for arithmetic and comparison.

[STREAM_TASK]
  name selectTaskWithTag
  exec SELECT record_tag(), rand_value 
 FROM TAG:'random-num';  #1

[STREAM_TASK]
  name selectSumTask
  exec SELECT now(), sum(rand_value) 
 FROM TAG:'random-num';  #2

[STREAM_TASK]
  name selectWhereTask
  exec SELECT unix_timestamp(), 
 count(rand_value) FROM TAG:'random-num' 
 WHERE rand_value > 0;      #3

How Logs and Telemetry covers it

How deep it goes

Defines query usage and shows output values but does not detail function implementation internals.

Examples

Demonstrates unix_timestamp() in a random-number stream query producing integer timestamps and counts.

What it assumes

Assumes familiarity with SELECT statements, tagged streams, WHERE clauses, and aggregate functions.

What you can do after

Apply it via a stream-processing query to emit numeric timestamps with filtered event counts.

How it connects

Connects timestamps with stream processing, SELECT queries, WHERE filtering, and aggregation through count().

liveBookmanning.com

Read Logs and Telemetry on liveBook Get the book at manning.com

Related concepts

• arbitrary-precision integerproduces · An integer representation that can accommodate values beyond fixed-width limits by expanding storage as needed, without loss of integer precision.
• Unix epochuses · The Unix epoch is the reference instant at 00:00:00 UTC on January 1, 1970, from which Unix time is measured.

This explainer was generated by Manning's knowledge graph from the text of Logs and Telemetry. The section links point to the parts of the book it draws on.