For questions about recording the last time, or datetime, a row was modified.
Often you will want meta-data pertaining to the last-time a row was modified. Most databases have developed special modules, macros, or procedures to get this effect,
- In PostgreSQL, see the
spi
'smoddatetime
function which is meant to be used in a trigger. - With MySQL, you would use
ON UPDATE CURRENT_TIMESTAMP