8

I have 13 digit number and want to create date and time with include milisecond

Example code is like this this is my php script

$mil = 1328910295939;
$seconds = $mil / 1000;
$showdate = date('Y:m:d H:i:s', $seconds) ;

echo "$showdate";

the result is like this 2012:02:10 15:44:55.xxx ===> xxx is 3 digit miliseconds that i want to show up.

and how to include with 3 digit milisecond after H:i:s

Please help me.....

Smith
  • 93
  • 1
  • 1
  • 5

6 Answers6

10

How about something like this?

$mil = 1328910295939;

function toTimestamp($milliseconds)
{
    $seconds = $milliseconds / 1000;
    $remainder = round($seconds - ($seconds >> 0), 3) * 1000;

    return date('Y:m:d H:i:s.', $seconds).$remainder;
}

echo toTimestamp($mil);

Tadaa!

It should be pretty quick too.

Also, this is the output: 2012:02:10 15:44:55.939 - why you're not using - for delimiting the date portion beats me.

Westie
  • 427
  • 3
  • 12
  • Thanks dude..... great work. u are the best, because iam searching for a week in internet does not have solution. – Smith Feb 12 '12 at 01:44
  • Hello westie i had still problem the HOUR time was 2 hour faster... example 22:07:45.434 an HOURS should be 20. – Smith Feb 14 '12 at 04:14
  • That's a problem with your server - you'll need to set the timezone. – Westie Feb 14 '12 at 10:09
  • @Westie Should left pad `$remainder` with zeroes if it has fewer than 3 digits. For example, if `$mil = 1328910295039`, the output should be `2012:02:10 21:44:55.039`, not `2012:02:10 21:44:55.39`. – Pang Jan 05 '17 at 06:39
5

Just trim off the last two characters:

substr(date('Y-m-d H:i:s.u',1328910295939), 0, -2)
Jon Grant
  • 11,369
  • 2
  • 37
  • 58
  • On my system, this evalutes to "2025-12-10 22:17:55.0000" (PHP 5.3.6 on Ubuntu) – iblue Feb 11 '12 at 18:36
  • this is my php script $mil = 1328910295939; $seconds = $mil / 1000; $showdate = date('Y:m:d H:i:s', $seconds) ; echo "$showdate"; the result is like this 2012:02:10 15:44:55 and how to include with 3 digit milisecond after H:i:s – Smith Feb 11 '12 at 18:54
4

Here's a function that will do it for you accurately (by rounding, not cutting off):

function getTimestamp()
{
        $microtime = floatval(substr((string)microtime(), 1, 8));
        $rounded = round($microtime, 3);
        return date("Y-m-d H:i:s") . substr((string)$rounded, 1, strlen($rounded));
}

Explanation:

microtime() returns 2 numbers as 1 string, delimited by a space. the 2nd number is the amount of seconds since the unix epoch, and the 1st number is the amount of microseconds since the 2nd number. Basically, the first number is the amount of microseconds expressed in a 8 precision format (0.00000000) and trailing 0s are never cut off.

We round this to a precision of 3 (0.00), and cut off the leading 0, and append that to the actual timestamp.

For some reason the php doc for u, microseconds, doesn't seem to be actually supported. I get 0.000 everytime when using that method. So I resorted to microtime() as a backup solution.

Vigrond
  • 8,148
  • 4
  • 28
  • 46
  • Example code is like this this is my php script $mil = 1328910295939; $seconds = $mil / 1000; $showdate = date('Y:m:d H:i:s', $seconds) ; echo "$showdate"; the result is like this 2012:02:10 15:44:55.xxx ===> xxx is 3 digit miliseconds that i want to show up. – Smith Feb 11 '12 at 19:04
  • 1
    The `u` format is supported for dates that contain microseconds (e.g. `DateTime` instances). The `date()` function only works with integer timestamps so does not know about fractional seconds. – salathe Feb 11 '12 at 21:43
1
$t = 1328910295939;
echo date('Y-m-d H:i:s.', substr($t, 0, -3)) . substr($t, -3);

Output: 2012-02-10 16:44:55.939 (it depends on the timezone)

Cheery
  • 16,063
  • 42
  • 57
0

Because these answers were all quite amusing in their complexity, here's yet another answer for future posterity that uses the asker's original code and doesn't treat numbers as strings.

$mil = 1328910295939;
$seconds = floor($mil / 1000);
$fraction = $mil % 1000;
$showdate = date('Y:m:d H:i:s',$seconds) . ".$fraction";

echo "$mil<br>
$seconds<br>
$fraction<br>
$showdate";

Outputs the following on a server set to the EST time zone:

1328910295939
1328910295
939
2012:02:10 16:44:55.939
Eric L.
  • 3,232
  • 2
  • 22
  • 20
0

Since I can't add a comment to the of @westie, and if anyone need this, I allow myself to add the missing line to his function for decimals < 100 :

    $seconds = $milliseconds / 1000;
    $remainder = round($seconds - ($seconds >> 0), 3) * 1000;
    $remainder = sprintf("%03d", $remainder);
    return gmdate('H:i:s.', $seconds).$remainder;

Note that I also use gmdate to prevent time zone issues (i suppose you would work on milliseconds for duration calculation and not date calculation)

Vianney
  • 31
  • 2