--TO_TIMESTAMP后面跟的是闪回到指定的时间段SELECT * FROM branch_user_dsc_info AS OF TIMESTAMP TO_TIMESTAMP('2017-04-25 14:00:00', 'yyyy-mm-dd hh24:mi:ss')