How do i show the final modified date, when my Mysql-database was up-to-date?

(I understand there's wordpress plugin for showing latest modified date for publish/pages, I wish to do similar, but show when fields/metadata was up-to-date)

Grateful for solutions"

Ok, solved it.


global $wpdb;
$result = $wpdb->get_results("SHOW TABLE STATUS FROM database_name LIKE 'table_name';");
foreach ($result as $data) {
    $updatetime = $data->Update_time;

$date = substr($updatetime, 0, -3);
echo $date;