Imagine the complexities of systems dealing with both perspectives of time, and the drift that can occur over… er… time. Particularly imagine the hypothetical c

Imagine the complexities of systems dealing with both perspectives of time, and the drift that can occur over… er… time. Particularly imagine the hypothetical complexities of a system where there’s any N > 1 civil time system. Space colonization is probably what springs to mind, but it wasn’t long ago (this past week if I’m not mistaken) that a civil time system without leap seconds was proposed for Earth and made it to the HN front page. It’s easy for things to go wrong when basic facts about time don’t line up. Not every set of things and wrong-going will rise to the level of what people imagined about Y2K, but I can personally attest to months of hell untangling and correcting records related to minute differences (sorry, accidental pun but I’m leaving it in) in how two very widely used RDBMSes keep time.