using JDBC how to move a record from one table to another within specified time limit

[Ashish Mohanty]

How to move records from one table to another table using a specified time limit eg:60 days old record should be moved from one table to another table.

Anyone please help me.

[Sudheer Bhat]

The better way to copy records from one to another is insert into table2 select * from table1 where created_date <= systemdate-60. This assumes that your table has a column to store the created date. The syntax might slightly differ from database to database.

[Ashish Mohanty]

Sudheer Bhat wrote:The better way to copy records from one to another is insert into table2 select * from table1 where created_date <= systemdate-60. This assumes that your table has a column to store the created date. The syntax might slightly differ from database to database.

But what exactly is the created date.both the table has same column name.

[Rob Spoor]

Then prepend the table name to the column: table1.created_date.