• Uh, hang on. So what you are saying is different parts of a datetime will represent different parts of the system?

    Why not just create a composite key that does that clearly?