Calculated/Generated Column for Unix Timestamp to Date/Time

[Paul Carass]

Hi All,
Completely new to using mySQL, but not new to databases.
I have a scenario where the Updated At/last modified column on our "user" table is in UNIX format.
I am using an iPaaS tool to integrate the DB with Salesforce, but in order to monitor for Updates to Rows, they need an "Order By" date/time column.

Is is possible to create a Generated Column (Calculated) on the particular table to return a date/time value, which we can then use to monitor for changes?

Any guidance here is much appreciated.
Thanks
Paul