/ 2.7, PYTHON, TIMESTAMP

Timestamp and microseconds on Windows platforms

The datetime.datetime object can return the current date and time with a resolution up to microseconds which is true on *nix platforms but not completely true on Windows platforms.

The problem

On both platforms, and at least with Python 2.7, the minimum resolution reported by datetime is 1 microsecond:

>>> import datetime
>>> datetime.datetime.resolution
datetime.timedelta(0, 0, 1)
>>> datetime.datetime.resolution.microseconds
1

but the datetime object returned by the datetime.now() function has a little difference between nixes and Windows systems. Onnixes consecutive calls to datetime.now() returns a sequence like this one:

>>> datetime.now()
datetime.datetime(2013, 7, 12, 19, 23, 38, 628596)
>>> datetime.now()
datetime.datetime(2013, 7, 12, 19, 23, 39, 244587)
>>> datetime.now()
datetime.datetime(2013, 7, 12, 19, 23, 39, 788556)

where the last number is the microsecond part of the datetime object. On Windows however the result is slightly different:

>>> datetime.now()
datetime.datetime(2013, 7, 12, 19, 25, 27, 741000)
>>> datetime.now()
datetime.datetime(2013, 7, 12, 19, 25, 28, 381000)
>>> datetime.now()
datetime.datetime(2013, 7, 12, 19, 25, 28, 956000)

we still have microseconds but something is not right: the microseconds are multiple of 1000 which means the actual minimum resolution for a datetime object returned by datetime.now() is 1 millisecond.

The solution

This is not an issue if you are handling timestamps like the major of use cases where a timestamp is involved. In my case however I needed a timestamp which was unique and consecutive which is satisfied on *nix systems, the code is not fast enough to be run in less than 1 microsecond, but not in Windows systems where the code is obviously fast enough to be run in less than 1 millisecond, raising an exception because the timestamp wasn’t unique and consecutive.

I made a workaround to simulate the microsecond resolution even on Windows system by using a microseconds generator:

import datetime
import sys

class Event(object):

    if sys.platform == "win32":
        import itertools

        _usec_generator = itertools.cycle(xrange(1000))

    def __init__(self):
        self.timestamp = datetime.datetime.now()

        if sys.platform == "win32":
            self.timestamp = self.timestamp.replace(
                microsecond=self.timestamp.microsecond + self._usec_generator.next()
            )

The _usec_generator uses the itertools.cycle iterator to return a number in the range 0..999 to be used as fake microsecond value for the datetime object. The generator will return an incremented number at every call adding the number to the current microsecond value.

Supposing I’m creating multiple Event instances in the same millisecond, the result will be:

>>> Event().timestamp
>>> datetime.datetime(2013, 7, 12, 20, 58, 25, 266000)
>>> Event().timestamp
>>> datetime.datetime(2013, 7, 12, 20, 58, 26, 266001)
>>> Event().timestamp
>>> datetime.datetime(2013, 7, 12, 20, 58, 26, 266002)

As you can see now the microseconds starts with a 000 but increment at every Event creation satisfying the requirement of an unique and consecutive timestamp.