modified the trigger to use the clock timestamp rather than now() since now() is relative to the start of a transaction