Site
Home / Forum / General Discussion / Incorrect Local Dates on Events (due to timezones)?

Incorrect Local Dates on Events (due to timezones)?


Posted: 26 Aug 2023 22:30
carlsore

Posts: 20
Joined: 2020

General question - is there a best practice for the site in regards to using the actual local dates of the event as the "event date" - for example, WWE Smackdown is a Friday show, so this most recent event was held in Louisville, KY, on August 25th (USA Eastern time zone). The listing for the event refers to it as being "August 26th", which I presume is just due to whoever adding it to the catalog being in a country/location where the show airs on Saturday instead.

It is confusing to have the filenames based on a date that wouldn't actually be the date of record of the event - is there any rule that we should treat event dates like airlines do, and use the local day/time based on where the event itself is actually happening?

Posted: 27 Aug 2023 18:12

Ovokx

Posts: 1,768
Joined: 2020

all events are created on UTC time

zag
Posted: 27 Aug 2023 20:20
carlsore

Posts: 20
Joined: 2020

That's not entirely true in practice though - https://thesportsdb.com/event/1783366

For example, this baseball game is happening at 0110 on Monday the 28th (in UTC), but it was set up ("correctly") as happening on Sunday the 27th, which all historical records of the game would consider to be accurate.

https://thesportsdb.com/event/1877860 > the Paul/Diaz card started at 8pm EST (7pm CST since it was in Texas), and we've got it correctly listed as happening on Saturday, August 5th, just like it says on the poster - even though UTC would say the fight was on Sunday, August 6th.

I get that we'd try to standardize a clock, but it still seems like the local event date/time would be more useful for a sports event, and again, for something that's heavily used as part of linking to media players like Plex/Kodi, having to use a different date just seems counterintuitive, vs. basing the auto filename determination off the local.

PS: I see someone's since updated the Smackdown listing I was looking at yesterday to include local times, which is nice but still means that if you search the DB for the August 25th Smackdown, there isn't one.

Posted: 29 Aug 2023 06:47
curswine


Posts: 938
Joined: 2020

That's not entirely true in practice though - https://thesportsdb.com/event/1783366

For example, this baseball game is happening at 0110 on Monday the 28th (in UTC), but it was set up ("correctly") as happening on Sunday the 27th, which all historical records of the game would consider to be accurate.[quote]

Did you update that baseball game? It correctly shows 23:10 UTC.

Baseball, and some other sports, are automated with their UTC date times so these should not be wrong.

[quote]https://thesportsdb.com/event/1877860 > the Paul/Diaz card started at 8pm EST (7pm CST since it was in Texas), and we've got it correctly listed as happening on Saturday, August 5th, just like it says on the poster - even though UTC would say the fight was on Sunday, August 6th.


You're right, it should be Sunday, I've updated it, but please update it yourself if you see anymore incorrect.

I get that we'd try to standardize a clock, but it still seems like the local event date/time would be more useful for a sports event, and again, for something that's heavily used as part of linking to media players like Plex/Kodi, having to use a different date just seems counterintuitive, vs. basing the auto filename determination off the local.

I try and add local times where I can, but UTC is the most useful thing to use.

Try taking it up with the developers of the Plex/Kodi scrapers. All we can do here is add events with correct dates and times.

Posted: 04 Sep 2023 19:03
carlsore

Posts: 20
Joined: 2020

Appreciated - and I just didn't see a way to change the entry myself since it would already have been set for the filename. I 100% agree that it's a bummer how the scrapers work, but I would just say that using the LOCAL event date/time is a better practice than worrying about having it in UTC. (I noticed AEW All Out is perfect even with the next day date on UTC, so maybe the entry I was looking at was just misentered to start?)

Thanks!

Posted: 05 Sep 2023 07:49

zag


Posts: 3,515
Joined: 2020

As a rule, we always use UTC time.

But as anyone can add events sometimes they do it with local time.


Who is Online?

In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm

About Us

Discussion forum for TheSportsDB.com site and related topics

Rules

- Be Polite
- Respect other users
- Always post log files with issues
- Try to be helpful
- No Piracy discussion

Showing 0 to 6 (Total: 6)