Which format is best for dates in PHP and MySQL?

  • Thread starter Thread starter sappy16
  • Start date Start date
S

sappy16

Guest
I am trying to create a website where users can upload certain information. I want to have 'date added' and 'date modified' columns (which record both date and time) in my database (I'm using PHP MyAdmin), but I'm not sure what is the best format to use, or what are the differences: DateTime, TimeStamp etc. Obviously, I want the 'date added' column to remain the same, but whenever the record is changed, I want to be able to change the 'date modified' column. I'm also not sure what the 'Current_Timestamp' default setting does - will it change if the record is updated?

Thanks
 
Back
Top