How do you change date for over 700 records at once

I imported my database from one host to another now I want to change the date to refect todays date on over 700 records is there a way besides one by one

 

This query updates ALL ROWS Datefield to now.

update YourTableName set DateFieldName = CURRENT_TIMESTAMP;

 

For ORACLE DB, you can do with these SQL commands:

update TableName set DateFieldName = sysdate;
commit;

Code (markup):

 

Thank you that worked perfectly