insert into 表名 select * from 表名 as of timestamp to_timestamp('2017-11-08 22:57:47', 'yyyy-mm-dd hh24:mi:ss');