title: How to let MySQL NOW() function return the user time
body: <p>I ran into a very tricky MySQL issue..
  Our DB is using type <code>DateTime</code> for the <code>updated_at</code> column, and now is too late to change it back to <code>TimeStamp</code>. I'm thus trying to add a trigger to update this <code>updated_at</code> column on table changing. The following is what I did:</p>
  
  <p><code>CREATE TRIGGER foo_schema.bar_datetime_trigger BEFORE UPDATE ON foo_schema.bar
  FOR EACH ROW
  set NEW.updated_at = NOW();</code></p>
  
  <p>The <code>NOW()</code> function here returns the DB time; however, what I actually want is to set the <code>udpated_at</code> as the user time (Meaning the time of the user who made changes to table <code>bar</code>). Is it possible to handle this in MySQL?</p>