problem with datetime field

Question

i have a php code like this:

   date_default_timezone_set('GMT');
    $date =date( "Y-m-d H:i:s");
    echo $date;

output is

2011-05-01 11:31:49

but when insert $date in Datetime column date is 2011-05-01 11:05:07

INSERT CODE:

    date_default_timezone_set("GMT");
    $date=date("Y-m-d H:m:s");
    $q="insert into TABLE values
    ('$date')";
mysql_query($q);

why?

What exactly do you insert into your database? And did you check the time settings of the mysql server? — Arjan
– Arjan, Commented May 1, 2011 at 11:47
it return same time with windows time. mysql server is localhost — user006779
– user006779, Commented May 1, 2011 at 12:18
Are you physically in GMT? Also, please let us know what your query looks like. — Muhammad Yasir
– Muhammad Yasir, Commented May 1, 2011 at 12:23
That's still not your query, table is a reserved work so you've just written a fake query for us to see what you did. But if you have an error in your true code, we won't be able to see it ;) — Jaffa
– Jaffa, Commented May 1, 2011 at 12:30

nos · Accepted Answer · 2011-05-01 13:10:10Z

2

Your first example uses $date=date("Y-m-d H:i:s"); which seems ok.

Your second example uses $date=date("Y-m-d H:m:s"); which seems strange, you're using the month(m) in the conversion for minutes.

answered May 1, 2011 at 13:10

nos

231k60 gold badges436 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1