CODEWITHSUNDEEP
phpmysqlsqltimestamp
Philip Kirkbride
Philip Kirkbride

Reputation: 22879

Change DateTime from mySql to timestamp in php

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();



}

Upvotes: 0

Views: 125

Answers (1)

John Woo
John Woo

Reputation: 263723

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
}

Upvotes: 4

Related Questions