AS OF SYSTEM TIME timestamp clause is available in some statements to execute them as of the specified time.
timestamp argument supports various formats.
||Nanoseconds since the Unix epoch.|
Assuming the following statements are run at
2016-01-01 12:00:00, they would execute as of
> SELECT * FROM t AS OF SYSTEM TIME '2016-01-01 08:00:00'
> SELECT * FROM t AS OF SYSTEM TIME 1451635200000000000
> SELECT * FROM t AS OF SYSTEM TIME '1451635200000000000'
HLC timestamps can be specified using a
DECIMAL. The integer part is the wall time in nanoseconds. The fractional part is the logical counter, a 10-digit integer. This is the same format as produced by the