title: Difference between mysql datetime timestamp time
body: <p>I want to get the current time when a login attempt is processed. I want to get the time retrieved in probably date and hour/min/sec.</p>
  
  <p>I have a database with a field called <code>last_attempt</code>, which holds the date and time of the last login attempt. </p>
  
  <p>Which of the types <code>Datetime</code>, <code>Timestamp</code>, <code>Time</code> or others should I use for the field? And also what method in PHP should I use?</p>