I hate time zones, especially when I'm stupid

The primary application at my job was...not well written. Originally .NET Framework 3.5 with a strange collection of approaches to MVC. SQL Server for data. I claimed it look like something written by CS students fresh out of college on their first job. Turned out I was close...it was written by 3rd-year CS interns. We've fixed and improved a ton (including migrating to .NET 6 earlier this year).

One of the ongoing issues was the use of SMALLDATETIME and DATE fields for everything. We've been gradually migrating these to DATETIME2 or DATETIMEOFFSET (we don't have future dates) as UTC. Because 95% of our usage had been CST/EST, we've typically set the time component to 17 hours to get a reasonable noonish time in those zones when we don't have a better time of day.

Had another round of these today and thought it was going well. Finally got it running and everything was +1 day from where it should be. Spent an hour trying to figure out the issue.

Converting for display incorrectly? No. Serializer not doing what was expected? No. Configured time zone got messed up? No. Brought in our DBA to help me figure it out.

I had added 17 days twice.

Side note: I wish everybody was on UTC time and time zones would forever disappear into the ether.

TLDR; Migrated time wrong because I'm stupid.

CHollman82,

I hate everything having to do with times, dates, and languages. It's like we are used to rigor and logic and human invented systems from millennia ago are anything but...

beardcrumbs,

After having tests work on my computer but mysteriously fail on test server I discovered that test server was set to UTC and tests that depended on having test data return the same time/date failed. Since it was not critical to test those edge cases we just offset times in test cases so that they didn't overflow into next day in our test server. It never gets boring when working with time and date.

Dathknight,

I feel you...

One of my services connects multiple systems. Some with timezone information some without. It is all a big guessing game ... Add some misconfigurations of VMs and you get some very interesting errors.

dolle,

Why are you migrating from DATE to DATETIME2? If the original data didn't need a time component then I don't see why you should add one.

vraylle,

Because it originally didn't account for time zones at all....it was very "everybody is in Virginia". The day was even wrong for many countries. When a training program shifted to include other countries it suddenly mattered. And it correlated to other data that did have times.

knighthawk0811,

Tom Scott has entered the chat

anji,

Classic Tom Scott agrees.

Penguincoder,

Timezone programming sucks. The philosophy I got by is, to store/track/log everything in UTC. When it is displayed, then change the format to the local user timezone IF NEEDED. For example if it's like network device logs or security events, one timezone (UTC normally) should be used, not changed for every user. Convert the reverse for input from client, to back end.

vraylle,

This only works out of you're not tracking future dates, but yeah, that's basically what we're doing. Server side is UTC, UI converts into user's zone for display and sends UTC back to the server.

duncesplayed,

Yeah the future dates (more future times, I guess) is something a lot of people neglect. "Do everything in UTC" is sadly not a magic bullet for all times.

First of all you need to decide if you really want UTC or if you actually want TAI. But if you do want UTC (and you do, a lot of the time), future times become a problem. If they're TAI, then you can't (always) predict exactly when they'll happen. If they're UTC, then you can't (always) predict exactly how far in the future they are.

OsrsNeedsF2P,

Side note: I wish everybody was on UTC time and time zones would forever disappear into the ether.

Everyone who has worked with dates feels this way. I for one have switched to the 24:00 clock and keep the UTC time as a widget on my phone. It won't happen in our lifetime, but I'll be damned if I'm not stubborn about it.

(Also as a side note, I work in game dev and I force everything to be in UTC. I don't care what the PM says, our events all reset midnight UTC)

vraylle,

I've been on military time since doing a lot military contracting.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • programming@beehaw.org
  • DreamBathrooms
  • mdbf
  • ethstaker
  • magazineikmin
  • GTA5RPClips
  • rosin
  • thenastyranch
  • Youngstown
  • osvaldo12
  • slotface
  • khanakhh
  • kavyap
  • InstantRegret
  • Durango
  • provamag3
  • everett
  • cisconetworking
  • Leos
  • normalnudes
  • cubers
  • modclub
  • ngwrru68w68
  • tacticalgear
  • megavids
  • anitta
  • tester
  • JUstTest
  • lostlight
  • All magazines
    •