Click here to Skip to main content
15,892,059 members
Articles / Programming Languages / SQL

Why "Store Everything in UTC" is Bad Advice

Rate me:
Please Sign up or sign in to vote.
2.99/5 (27 votes)
4 Aug 2021CPOL7 min read 21.4K   8  
Let's explain the basics so developers understand weak spots of date and time handling
Handling dates and times is not an easy part of the software development and in many cases, we see implementations working only in limited scope of scenarios, usually failing later with data malformed in a way that is hard to fix.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect ABB
Czech Republic Czech Republic
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions