title: Difference between UNIX_TIMESTAMP and NOW() in MySQL
body: <p>I have a blog where users can comment. I insert the time at which they posted a comment using <code>NOW()</code> and then use <code>date('j M Y', stored timestamp)</code> to show the time at which they posted.</p>
  
  <p>I want to know does NOW() return the <code>locatime of the end user or the localtime at my server</code>.
  Is it better suited to use <code>UNIX_TIMESTAMP</code> than <code>NOW()</code> to calculate the localtime at which users posted a comment.</p>