Default for you timpstamp filed to (getdate()). This will get ther Now time and date when inserting new record.