Re: Update column when datetime = NOW()

[Peter Brawley]

You said you need something to fire an update of the table. You do not. Given a View that defines a timestamp_value < Now() column, no such update is ever required.

If you have a number of such timestamps, and there is a requirement to notify certain users when certain timestamps reach a criterion date & time, you could create a notification table with a row for each such timestamp value, define Insert and Update Triggers to populate notification rows with notification times and email addresses of who's to be notified, have the app always track the next notification date in that table and watch the clock every minute or so, and fire off required notices when such times are reached.