我应该把时间旅行时间戳放在哪里

Question

我有一个类似的查询

SELECT Table1.MTH_COD, Table1.ID, Table1.ETV_FLG,Table2.EXT_FLG, Table2.GEN_COD, Table3.AMOUNT_VALUE, Table3.CUR_IDT_COD as "Table3.CUR_IDT_COD"
from "Database"."Schema"."Table" as Table1 
JOIN "Database"."Schema"."Table" as Table2
ON Table1.MTH_COD=Table2.MTH_COD
AND Table1.ID=Table2.ID
LEFT JOIN "Database"."Schema"."Table" as Table3
ON Table1.MTH_COD=Table3.MTH_COD
AND Table1.GRADE_COD=Table3.GRADE_COD
WHERE Table1.CLASS_COD IS DISTINCT FROM (select CLASS_COD_ID from "Database"."Schema"."ReferentialTable" 
where CLASS_COD = 'DE')
AND EXT_FLG = 0

我想在这里添加at(timestamp => '2022-08-25 12:00:00'::timestamp)，但我尝试了好几次，无法正确插入

Answer 1

将其放在任何表名之后，但放在任何别名之前

例如

FROM table1 at(timestamp => '2022-08-25 12:00:00'::timestamp) as mytable
JOIN table2 at(timestamp => '2022-08-25 12:00:00'::timestamp) on...