The Fauna service will be ending on May 30, 2025.

For more information on the service wind down, see our announcement and the Fauna Service End-of-Life FAQ.

ToMillis

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.

 
ToMillis( value )
to_millis( value )
ToMillis( value )
ToMillis( value )
ToMillis( value )
ToMillis( value )

Description

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

Attempting to convert a value to a number of milliseconds 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 milliseconds 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 milliseconds since Unix epoch.

Examples

The following query calls ToMillis twice:

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

  2. To convert the current transaction time into milliseconds.

client.query([
  q.ToMillis(q.Epoch(1, 'second')),
  q.ToMillis(q.Time('2020-07-06T12:34:56.789Z')),
])
.then((ret) => console.log(ret))
.catch((err) => console.error(
  'Error: [%s] %s: %s',
  err.name,
  err.message,
  err.errors()[0].description,
))
[ 1000, 1594038896789 ]
result = client.query(
  [
    q.to_millis(q.epoch(1, 'second')),
    q.to_millis(q.time('2020-07-06T12:34:56.789Z')),
  ]
)
print(result)
[1000, 1594038896789]
result, err := client.Query(
	f.Arr{
		f.ToMillis(f.Epoch(1, "second")),
		f.ToMillis(f.Time("2020-07-06T12:34:56.789Z")),
	})

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}
[1000 1594038896789]
try
{
    Value result = await client.Query(
        Arr(
            ToMillis(Epoch(1, "second")),
            ToMillis(Time("2020-07-06T12:34:56.789Z"))
        )
    );

    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}
Arr(LongV(1000), LongV(1594038896789))
System.out.println(
    client.query(
        Arr(
            ToMillis(Epoch(1, "second")),
            ToMillis(Time("2020-07-06T12:34:56.789Z"))
        )
    ).get());
[1000, 1594038896789]
[
  ToMillis(Epoch(1, 'second')),
  ToMillis(Time('2020-07-06T12:34:56.789Z'))
]
[ 1000, 1594038896789 ]
Query metrics:

  •    bytesIn:  93

  •   bytesOut:  33

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 4ms

  •    retries:   0
\