title: What difference between the DATE, TIME, DATETIME, and TIMESTAMP Types
body: <p>I need to store both <strong>time</strong> and <strong>date</strong> in the mysql. So I used of <code>NOW()</code> function for that. But I don't know what should I use for <em>type column</em> im phpmyadmin. It should be noted that <code>NOW()</code> returns both time and date like this:</p>
  
  <pre><code>2014-11-11 12:45:34
  </code></pre>
  
  <p>Here is a solution, I can use of a separator for separating date and time (<code>2014-11-11</code> and <code>12:45:34</code>) and then store them in the DATE type and TIME type individually. Or I can use of VARCHAR type for storing both of them in one column. But I think these ways are not standard. what is standard type for storing both date and time ?</p>
  
  <p>Here is my query: (also I don't know why <code>NOW()</code> function does not works)</p>
  
  <pre><code>INSERT INTO table (timedate) VALUES (NOW())
  </code></pre>