`Epoch`

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

Epoch( num, unit )

Description

The Epoch function constructs a Timestamp relative to the Unix epoch (1970-01-01T00:00:00Z).

The num argument must be an integer value. The unit argument specifies the scale of num.

Parameter Type Definition and Requirements

Parameter	Type	Definition and Requirements
`num`	Number	A mathematical integer value specifying the offset from epoch.
`unit`	String	Indicates the units used by `num`. Must be one of: `day`, or `days` `half day`, or `half days` `hour`, or `hours` `minute`, or `minutes` `second`, or `seconds` `millisecond`, or `milliseconds` `microsecond`, or `microseconds` `nanosecond`, or `nanoseconds`

num

Number

A mathematical integer value specifying the offset from epoch.

unit

String

Indicates the units used by num. Must be one of:

A Timestamp which represents Unix epoch plus the offset represented by num and unit.

The following query adds 0 seconds to the Unix epoch (1970-01-01T00:00:00Z) and returns a timestamp:

Epoch(0, 'second')

Time("1970-01-01T00:00:00Z")

Query metrics: