title: Dealing with Time in Php/Mysql
body: <p>Im very confused. For example I'm adding a record which time should be also filled up, then I filled up the the time textbox with format like this 6:30 pm. </p>
  
  <p><code>So how could I store this data into mysql database? What data type should I use?Because there are time,datetime and timestamp datatypes. What PHP functions should I use.</code></p>
  
  <p>What exactly I wanted to achieve is to get user inputted time with the format H:MM am/pm (e.g 6:30 pm), store it in a database the proper way, and display or retrieve this data with formatting exactly the way it was entered. </p>
  
  <p>Could anyone please help me understand how to store and retrieve times in mysql using Php. Please give me examples. </p>
  
  <p>I know there are so many resources on the web, but I want direct and clear answers for just a newbie like me in programming.</p>