I have a table with 36 columns (transaction).
from the 36 fields 3 fields populate the timestamp: time_field1, time_field2 and time_field3.
I want to populate all the records in the transaction table that meet the following condition:
if the greatest value among the following fields: time_field1, time_field2 and time_field3 is behind the current time by 2 h
in an other word
Compare the values of time_field1, time_field2 and time_field3, consider the latest (Max), compare that Max to current timestamp, if the difference is > 2h then populate the records