title: Query database for last modified date
body: <p>I am trying to query my Wordpress server to echo the date of the last modified post.<br />
  In this case the database name is local and I am checking the posts table.</p>
  <p>My current code is close to what I need, it will display the date and time as <code>Y-m-d H:i</code> (2021-01-13 12:18)</p>
  <pre><code>&lt;?php
  
  global $wpdb;
  $result = $wpdb-&gt;get_results(&quot;SHOW TABLE STATUS FROM local LIKE 'wp_posts';&quot;);
  foreach ($result as $data) {
      $updatetime = $data-&gt;Update_time;
  }
  
  $date = substr($updatetime, 0, -3);
  echo $date;
  
  ?&gt;
  </code></pre>
  <p>How do remove the time and display the date as <code>d.n.Y</code>?</p>