microtime to standard date format

php date milliseconds microtime
Justin Erswell picture Justin Erswell · Oct 8, 2012 · Viewed 13.8k times · Source

I Have some values which are milliseconds since epoch i.e. microtime(true) in my MySQL database these are got out as strings I need to convert them over to a standard PHP date()

$updated = 1349697975.9381;
$nUpdated = date($updated, "l jS F \@\ g:i a");

This is returning a blank string, anyone help?

Answer

Baba picture Baba · Oct 8, 2012

It should be date ( string $format [, int $timestamp = time() ] )

You got the position wrong

   $nUpdated = date("l jS F \@ g:i a",$updated);

Output

Monday 8th October @ 2:06 pm

Related questions

Converting date (with milliseconds) into timestamp

I have date format like '25 May 2016 10:45:53:567'. I want to convert into the time stamp. strtotime function returns empty. $date = '25 May 2016 10:45:53:567'; echo strtotime($date); // returns empty When I removed the milliseconds, it's working. $date = '25 May 2016 10:45:53'; …

Read More
Convert a date format in PHP

I am trying to convert a date from yyyy-mm-dd to dd-mm-yyyy (but not in SQL); however I don't know how the date function requires a timestamp, and I can't get a timestamp from this string. How is this possible?

Read More
How do I use PHP to get the current year?

I want to put a copyright notice in the footer of a web site, but I think it's incredibly tacky for the year to be outdated. How would I make the year update automatically with PHP 4 or PHP 5?

Read More