INSERT INTO TABLE_NAME
(SELECT * FROM TABLE_NAME AS OF TIMESTAMP TO_TIMESTAMP('20090101000000,'YYYYMMDDHH24MISS'))