PHP equivalent of UNIX_TIMESTAMP() of MySQL?

Question

In MySQL:

select UNIX_TIMESTAMP('2009-12-08 21:01:33') ;

I need to get the value from PHP.

Answer 1

echo time();

or

echo strtotime('now');

• http://php.net/manual/en/function.time.php
• http://php.net/manual/en/function.strtotime.php

strtotime will:

Parse about any English textual datetime description into a Unix timestamp

So you might just try:

echo strtotime('2009-12-08 21:01:33');

Answer 2

strtotime()

Answer 3

mktime(21, 1, 33, 12, 8, 2009); // mktime($hours, $minutes, seconds, $month, $day, $year)

In addition, mktime() function is also can be used for this purpose. However you need to provide parameters, but an advantage of this function - you can get timestamp for the desired date and time, not only current timestamp.

Also your need to remove '0' from the beginning of the value. In other case these values will be recognized as octal.(08 => 8, 01=>1).

Answer 4

In case that you are not asking which is the equivalent UNIX_TIMESTAMP function in php. But you ask how to convert UNIX_TIMESTAMP() returned value to php DateTime object. Then you you can do it by prepending a "@" in time returned by sql query before passing it at DateTime constructor.

Like this:

$tm = new DateTime('@' . $sqlrow['time']);