I had to look up TAI. I disagree. UTC exists for a reason. But I am here to tell a war story.
Before I arrived on the scene a customer said they wanted local time in the reports. (As in Wall Clock Time).
The Customer is Always Right. OK?
So the times went into the database as wall clock time.
The designers of the data schema made a simplifying decision to store everything as text.
No time zone went into the text string that described the time. (?? I do not know why. So easy it would have been)
I come along and have to code animations using that time series data.
Very few problems...
As you would expect there are a lot of other problems with that database.
I had to look up TAI. I disagree. UTC exists for a reason. But I am here to tell a war story.
Before I arrived on the scene a customer said they wanted local time in the reports. (As in Wall Clock Time).
The Customer is Always Right. OK?
So the times went into the database as wall clock time.
The designers of the data schema made a simplifying decision to store everything as text.
No time zone went into the text string that described the time. (?? I do not know why. So easy it would have been)
I come along and have to code animations using that time series data.
Very few problems...
As you would expect there are a lot of other problems with that database.