Storing a date in mysql database

Question

I use this code in php to generate the current date/time

$time = date("m.d G:i:s T Y");

Now i need to store the value in time in mysql table

However it is show as illegal in my table , that is as 0000-00-00 00:00:00

The datatype used by my column is datetime

Thanks for helping me fix it:)

Answer 1

You try like this

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

Because mysql datetime must be in YYYY-MM-DD H:I:S format.. Otherwise the data inserted in that field will be 0000-00-00 00:00:00.

You can refer to these links for more reference

Link 1

Link 2

Answer 2

use this

date('Y-m-d H:i:s',strtotime($time));