title: What is the best data type for DATE and TIME
body: <p>I have an application that saves the date and time of a transaction. My initial database design is to create separate fields for <code>DATE</code> as date and <code>TIME</code> as varchar. My second option is to have a single field with <code>DATETIME</code>.</p>
  
  <p><strong>What is the difference of these two??</strong></p>