PHP Time Stamp Add to MySQL

[dmcdaniel]

Hello Everyone,

 

I am trying to add a PHP Time Stamp to my MySQL database. Anyone have any ideas? When the person hits Submit - I want DD/MM/YYYY HH:MM:SS to go into the database. What would be the best option?

 

Thank you,

DMcDaniel

[kenrbnsn]

Whenever you store date/time in a MySQL database always use the DATETIME standard format YYYY-MM-DD HH:MM:SS. This will make your life much easier. You can then display it anyway you want.

 

Ken

[ChaosKnight]

$date = date("Y-m-d H:i:s", time());

[Mchl]

MySQL actually has TIMESTAMP datatype for such purposes. Declare column as TIMESTAMP DEFAULT CURRENT_TIMESTAMP (it has to be first TIMESTAMP column in a table).