Time Travel query based on Timestamp Literal - Teradata Vantage

The following examples show how to query a table based on a Timestamp. The timestamp literal must be specified according to the Teradata syntax.

Iceberg

SELECT * FROM datalake_iceberg_glue.vim.cdata
   FOR SNAPSHOT AS OF TIMESTAMP'2023-06-15 00:08:01.119';
 *** Query completed. 2 rows found. 12 columns returned. 
 *** Total elapsed time was 2 seconds.
   price  1.61759576000000E 004
 mileage  19095
    make  Saturn
   model  L Series
    trim  Lx300 Sedan 4D
    type  Sedan
cylinder  6
   liter  3.00000000000000E 000
   doors  4
  cruise  1
   sound  1
 leather  0
   price  1.57311329000000E 004
 mileage  20484
    make  Saturn
   model  L Series
    trim  Lx300 Sedan 4D
    type  Sedan
cylinder  6
   liter  3.00000000000000E 000
   doors  4
  cruise  1
   sound  1
 leather  0

Delta Lake

select * from delta_unity.dlwtestnv.dlw_test_tab10 for snapshot as of timestamp '2024-09-23 08:42:09';
 *** Query completed. One row found. 2 columns returned.
 *** Total elapsed time was 8 seconds.
    col1  DOne
    col2  1