Time in our current universe can be modelled using 28 granularities, which is kind of cool because 28 is the idealized period of the cycle of the moon, and breaks down into 7 * 4.
But main reason is because it can model every degree of granularity of time. Consider it a "timespan" model, and below are some old models I used, with the SQL being the final model.
The time table can be used for a duration, or a point.
A timespan can be represented as stuff like this:
{ GIGAYEAR: 4, MEGAYEAR: 6 } // 4.6 billion years