jhauserw3241 / cdcdb-webserver

Python3/Flask web server for DB final project
https://cdcdb.system33.pw
1 stars 1 forks source link

Events Relative date is wrong #36

Closed Deedasmi closed 7 years ago

Deedasmi commented 7 years ago

Current time: 3:27 CST Event time: 18:00-19:00... EST? General Meeting Volunteer Presentations 3 hours ago 1 hour

pastly commented 7 years ago

Hey I wasn't the only one that noticed.

We've been putting dates in as central time (because that's where you guys are, and the human shouldn't necessarily be expected to specify the timezone), there's probably no timezone information in the DB (or it assumes you gave it UTC), and then the DB probably fetches times and assumes Eastern because that's the system timezone.

Fun stuff, eh?

Deedasmi commented 7 years ago

Web page is off by 5-6 hours, so it's not assuming EST.

pastly commented 7 years ago

That simplifies it because Central Time is UTC - 6hours right now.

pastly commented 7 years ago

See notes in commit. Time deltas will be off by an hour for y'all midwestern farmers. As soon as the server moves to CDC's barnyard server room, nothing will be wrong.