ToMicros

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.
Copied!
ToMicros( value )

Description

The ToMicros function converts a value to the number of microseconds since Unix epoch (midnight, January 1, 1970), if possible.

Attempting to convert a value to a number of microseconds which has no numeric representation results in an "invalid argument" error.

Parameters

Parameter Type Definition and Requirements

value

Any

The value to attempt to convert to a number of microseconds since Unix epoch.

If you provide a Number, it is interpreted as the number of microseconds since Unix epoch.

Returns

A Number representing the number of microseconds since Unix epoch.

Examples

The following query calls ToMicros twice:

  1. To convert 1 second after Unix epoch into microseconds.

  2. To convert the current transaction time into microseconds.

Copied!
[
  ToMicros(Epoch(1, 'second')),
  ToMicros(Time('2020-07-06T12:34:56.789Z'))
]
[ 1000000, 1594038896789000 ]
Query metrics:

  •    bytesIn:  93

  •   bytesOut:  39

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 5ms

  •    retries:   0
\