Warning:CockroachDB v1.0 is no longer supported. For more details, see the Release Support Policy.
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'
Note:Although the following format is supported, it is not intended to be used by most users.
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