getting a timestamp from an database insert/update when there is no timestamp field

I'm investigating an anomaly regarding two addresses in the address_book table. As part of that it would be most useful to know when exactly the two addresses were inserted/new records created.
Is that information possible to extract from the database, given that this table has no timestamp column, or is there any other concurrent db activity action to this insert that may give me such information?

torvista:

I'm investigating an anomaly regarding two addresses in the address_book table. As part of that it would be most useful to know when exactly the two addresses were inserted/new records created.
Is that information possible to extract from the database, given that this table has no timestamp column,

To the best of my knowledge, without a timestamp column there is no way to know when exactly when the records were added.

torvista:

or is there any other concurrent db activity action to this insert that may give me such information?

If you have the MySQL logging and/or replication enabled you may be able to find the info from there. Otherwise the only other thing you may find useful is to compare the address_book_id numbers as this will let you know the order that the address were added, which may or may not be useful.

Cheers
Rod

Thanks, as I thought.
So, moving on and trying to add a last_updated timestamp field to the address_book table, I was not having any success in integrating it into the current sql in header.php in address_book_process.
The problem was the 'type' as anything apart from 'noquotestring' (like 'string' or 'date') produced no result.
So just for the record/Google this is how I added a timestamp to a sql query.

Original

$sql_data_array= array(array('fieldName'=>'entry_firstname', 'value'=>$firstname, 'type'=>'string'),
                           array('fieldName'=>'entry_lastname', 'value'=>$lastname, 'type'=>'string'),
                           array('fieldName'=>'entry_telephone','value'=>$telephone, 'type'=>'string'),
                           array('fieldName'=>'entry_street_address', 'value'=>$street_address, 'type'=>'string'),
                           array('fieldName'=>'entry_postcode', 'value'=>$postcode, 'type'=>'string'),
                           array('fieldName'=>'entry_city', 'value'=>$city, 'type'=>'string'),
                           array('fieldName'=>'entry_country_id', 'value'=>$country, 'type'=>'integer'),
                           );

Modified
The db field is defined as datetime.

$sql_data_array= array(array('fieldName'=>'entry_firstname', 'value'=>$firstname, 'type'=>'string'),
                           array('fieldName'=>'entry_lastname', 'value'=>$lastname, 'type'=>'string'),
                           array('fieldName'=>'entry_telephone','value'=>$telephone, 'type'=>'string'),
                           array('fieldName'=>'entry_street_address', 'value'=>$street_address, 'type'=>'string'),
                           array('fieldName'=>'entry_postcode', 'value'=>$postcode, 'type'=>'string'),
                           array('fieldName'=>'entry_city', 'value'=>$city, 'type'=>'string'),
                           array('fieldName'=>'entry_country_id', 'value'=>$country, 'type'=>'integer'),
                           array('fieldName'=>'last_updated', 'value'=>'now()', 'type'=>'nostringquote')
                           );