title: Alternative for from_unixtime in GENERATED ALWAYS query
body: <p>Unfortunately, MySQL/MariaDB no longer supports using <code>from_unixtime</code> in Stored Generated Always columns, I am trying to generate values in a column automatically from another column that contains timestamp values. I have this</p>
  <pre><code>ALTER TABLE messages 
  ADD COLUMN only_date DATE GENERATED ALWAYS AS from_unixtime(timestamp_column, '%Y-%M-%D') STORED;
  </code></pre>
  <p>Can someone please help with an alternative that works? Thanks.</p>