microtime to standard date format
Asked Answered
D

2

5

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?

Despairing answered 8/10, 2012 at 14:42 Comment(0)
I
10

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
Indelicate answered 8/10, 2012 at 14:43 Comment(2)
I don't understand the second backslash, what does it escape? :) +1Phlegmy
Mihai Iorga was taling about `\@` @Justin ErswellIndelicate
W
0

You have the arguments to date() backwards (the timestamp is the second parameter).

Try updating to:

$nUpdated = date("l jS F \@ g:i a", $updated);
Weanling answered 8/10, 2012 at 14:44 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.