title: Best practices to insert time/time stamp in mysql
body: <p>I've had some trouble choosing an efficient way to insert a time in mysql database.</p>
  
  <p>I know mysql has its own timestamp system but it is not what I'm looking for.
  I currently use <code>date("Y-m-d  H:i:s", time());</code> and it gets the job done.</p>
  
  <p>But I would like to know what the standard is or what the best practices are to insert time that make it <strong>easier for retrieval later</strong>.</p>
  
  <p>Thanks.</p>
  
  <p><em>ps. I've searched the site for any dupe posts but I could not find any, if you think this is a dupe feel free to close</em>.</p>