select * from table as of timestamp to_timestamp('2022-12-14 03:00:00','yyyy-mm-dd hh24:mi:ss')
其中table 为待找回数据表
后面可添加过滤排序
select * from table as of timestamp to_timestamp('2022-12-14 03:00:00','yyyy-mm-dd hh24:mi:ss') where 1=1 order by 属性名
select * from table as of timestamp to_timestamp('2022-12-14 03:00:00','yyyy-mm-dd hh24:mi:ss')
其中table 为待找回数据表
后面可添加过滤排序
select * from table as of timestamp to_timestamp('2022-12-14 03:00:00','yyyy-mm-dd hh24:mi:ss') where 1=1 order by 属性名