I edited my comment to make it clearer. I meant you should only directly store current timestamps, anything else you should leave up to a library to store as it sees fit.

How would this solve the British Columbia issue as described in the article?

Your time library is not going to design your database schema for you.