select * from zw10 as of timestamp to_timestamp(‘2020-11-03 08:00:00’,‘yyyy-mm-dd hh24:mi:ss’) where zwe001=‘1103-3-0017’;
某个时间的表
create table appraise_log as SELECT * FROM order_conf WHERE 1=2;
建表,1=2就是不要数据
select * from zw10 as of timestamp to_timestamp(‘2020-11-03 08:00:00’,‘yyyy-mm-dd hh24:mi:ss’) where zwe001=‘1103-3-0017’;
某个时间的表
create table appraise_log as SELECT * FROM order_conf WHERE 1=2;
建表,1=2就是不要数据