Change DateTime from mySql to timestamp in php

Question

In my mysql database dateTime is stored in the following form.

00000-00-00 00:00:00

In my php I want to convert it to tiemStamp form like this.

136716425

I tried using

$date2->getTimestamp();

without success, what function should I use to change the format to timestamp?

$sql = "SELECT * FROM temp_user";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {

    $date1 = new DateTime();
    $date2 = $row[dateTime];

    echo $date1->getTimestamp();
    echo $date2->getTimestamp();



}

duplicate

Frédéric Clausset
– Frédéric Clausset

2013-04-28 16:01:03 +00:00
Commented Apr 28, 2013 at 16:01 — Frédéric Clausset
– Frédéric Clausset, Commented Apr 28, 2013 at 16:01
That solution doesn't work in this situation. ><

Philip Kirkbride
– Philip Kirkbride

2013-04-28 16:07:19 +00:00
Commented Apr 28, 2013 at 16:07 — Philip Kirkbride
– Philip Kirkbride, Commented Apr 28, 2013 at 16:07

John Woo · Accepted Answer · 2013-04-28 16:06:05Z

4

MySQL has a builtin function for that called UNIX_TIMESTAMP

SELECT UNIX_TIMESTAMP(NOW())

UPDATE

$sql = "SELECT *,UNIX_TIMESTAMP(dateTime) unx FROM temp_user";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) 
{
    $var = $row['unx'];
    // other codes
}

edited Apr 28, 2013 at 16:06

answered Apr 28, 2013 at 15:57

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

1 Comment

Philip Kirkbride Over a year ago

Have updated with a code sample. Not sure how I would integrate what you have posted here into that code, as I'm selecting more then just date from SQL.

Collectives™ on Stack Overflow

Change DateTime from mySql to timestamp in php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related