Versions Compared

Old Version 14

changes.mady.by.user Feng Jin

Saved on

compared with

New Version 15

changes.mady.by.user Feng Jin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

We propose add the following syntax for time travel statement.   In the SQL 2011 standard[1], syntax related to Time Travel is defined.

Code Block
languagesql
-- Specify a specific time
SELECT * FROM paimon_tb AS OF TIMESTAMP '2023-04-27 00:00:00'

-- Specify a constant expression
SELECT * FROM paimon_tb AS OF TIMESTAMP '2023-04-27 00:00:00' - INTERVAL '1' DAY

...