ansaurus

Question

18 digit timestamp?

Answer 1

+6 A:

It looks like C#'s DateTime ticks:

The DateTime value type represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001 Anno Domini (Common Era) through 11:59:59 P.M., December 31, 9999 A.D. (C.E.)

This line:

Console.WriteLine (new DateTime (633936042047633656));

prints:

11/12/2009 6:30:04 AM

If you need to convert from those numbers to Unix time, substract 621355968000000000L, which is the Unix epoch expressed in ticks.

Gonzalo 2009-12-02 12:59:02

Hmm, with no 64 bit int in PHP that could be an issue :P Oh well, i'll find a way.

Aaron Cowie 2009-12-02 13:29:13

Shouldn't be too hard to do that math in 32 bits, with a bit of string preprocessing. First "divide" by a million by removing the last 6 characters of the string, then remove the leading "6". Next subtract 2 from the first digit of the string. Now convert what's left to a 32 bits integer, and subtract 1355968000.

MSalters 2009-12-02 15:56:01

Answer 2

A:

With the gmp lib installed in php you can do it like this:

$epoch     = '621355968000000000';
$newtime   = gmp_sub($dateTime, $epoch);
$newtime   = gmp_div($newtime, '10000000');
$timestamp = gmp_strval($newtime);

and now you got a date:

echo date('Y-m-d H:i:s', $timestamp);

Janek 2009-12-02 15:01:33

ansaurus

tags:

views:

answers:

18 digit timestamp?

related questions