Questions tagged [row-modification-time]

For questions about recording the last time, or datetime, a row was modified.

Filter by
Sorted by
Tagged with
4
votes
2answers
2k views

Create a trigger on all the last_modified columns in PostgreSQL

In PostgreSQL 9.5, I have tables with columns in the form prefix_last_modified timestamp without time zone NOT NULL DEFAULT (clock_timestamp() AT TIME ZONE 'UTC') I was looking for a way to set ...
3
votes
1answer
4k views

Export just rows modified in last month (date defined by user)

I'm asking if it's possible in MySQL to export just rows modified in a period of time for example in the past month, if it is possible, how?
2
votes
1answer
353 views

Storing the last updated date of a row in a different table

I need to do a daily export of all of the new rows or updated rows from a legacy database into the new database. The problem I am running into is that not all of the tables on the legacy database ...