title: Which is the correct datatype to store time in SQL?
body: <p>Here's my table right now (using mysql):</p>
  
  <pre><code>SQL Table: koko_table
    name varchar(140)
    status varchar(140)
    time TIMESTAMP
  </code></pre>
  
  <p>My issue basically is , I have a form (using php) which user uses to store data only in the status column, my time column captures the time as a permanent data when the user stores in the status column. I think I have not been using accurate DATATYPE for time column, because everytime I visit my database, the time column has different values.</p>
  
  <p>What can be the correct datatype to store time of status input by the user as  un-changeable data.</p>