Comment on British Columbia, Time Zones, and PostgresparentComments−merb2moIn that case only storing utc did not work when you created a date in the future before you updated tzdata−jedberg2moI 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.−phantom7842moHow would this solve the British Columbia issue as described in the article?−eduction2moYour time library is not going to design your database schema for you.
Comments
In that case only storing utc did not work when you created a date in the future before you updated tzdata
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.