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:)

score 1 · Answer 1 · edited May 23 '17 at 10:26

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

edited May 23 '17 at 10:26

Community

answered Mar 26 '14 at 04:43

Deepu

i need to store the Timezone abbreviation as well , that's why there is a `T` in the command – user2650277 Mar 26 '14 at 04:54

score 0 · Answer 2 · answered Mar 26 '14 at 04:43

0

use this

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

answered Mar 26 '14 at 04:43

Deepak Rai

i need to store the Timezone abbreviation as well , that's why there is a T in the command – – user2650277 Mar 26 '14 at 04:55
1

Then store that abbreviation in another column. Or store it all as a varchar. – Rimble Mar 26 '14 at 04:56
Its not possible to store it in same column...i don't mind changing the data type – user2650277 Mar 26 '14 at 05:12

2 Answers2