Microseconds

first attempt to add full support for microsecond resolution, comes with a major improvement of the tests for TIME, DATE and DATETIME.

At the very least, this can be built upon.
This delicate case logic is repeating. Might make sense to extract a small helper.