Site
Home / Forum / General Discussion / [Split] UTC and local event times

[Split] UTC and local event times


Posted: 30 Aug 2019 14:57

ovokx
Posts: 830
Joined: Jan 2017

[quote="zag":1s1622oo]
- New "Add report" button on the events page to add newspaper or online event reports. Works with BBC and Gaurdian at the moment only but let me know if you want any other publication sources.


I would love to add reports from Marca.com, but currently it doesn't work

Posted: 31 Aug 2019 10:08

zag
Posts: 1,558
Joined: Oct 2016

Hmm yeh this has been a question in my head for a while with no easy answer, the issue is not all events even have the UTC time listed in the first place on websites, generally its local time with no other option.

In the past I have used a UK website (https://www.flashscores.co.uk) to find american schedules and this was a mistake as the day sometimes was wrong due to the time difference. Local time/date in that case would have been better.

I think the best way is to offer both for now, but i'm open to ideas on this one!

Posted: 31 Aug 2019 10:30

ovokx
Posts: 830
Joined: Jan 2017

Hmm yeh this has been a question in my head for a while with no easy answer, the issue is not all events even have the UTC time listed in the first place on websites, generally its local time with no other option.

In the past I have used a UK website (https://www.flashscores.co.uk) to find american schedules and this was a mistake as the day sometimes was wrong due to the time difference. Local time/date in that case would have been better.

I think the best way is to offer both for now, but i'm open to ideas on this one!


OK, but I Think that the fields should be switched. The old field should be the UTC as all the events currently added there are UTC and the new one for "local time". Also I keep thinking that should be created a new date field to add dates in a local way.

Take into account that I personally enter all TV info in UTC way (date & time) as the source that I'm using (https://sport-tv-guide.live/) let me select on that and correctly switch between correct date & time

Posted: 31 Aug 2019 12:16

zag
Posts: 1,558
Joined: Oct 2016

OK, but I Think that the fields should be switched. The old field should be the UTC as all the events currently added there are UTC and the new one for "local time". Also I keep thinking that should be created a new date field to add dates in a local way.

Take into account that I personally enter all TV info in UTC way (date & time) as the source that I'm using (https://sport-tv-guide.live/) let me select on that and correctly switch between correct date & time


Ok yep agreed, I have now swapped over the fields so UTC time is the primary and Local time is option secondary. Lets see how that works for now..

Posted: 31 Aug 2019 12:50

ovokx
Posts: 830
Joined: Jan 2017



Ok yep agreed, I have now swapped over the fields so UTC time is the primary and Local time is option secondary. Lets see how that works for now..


Posted: 31 Aug 2019 13:12

zag
Posts: 1,558
Joined: Oct 2016

Sure done!

Example: https://www.thesportsdb.com/event/602165

Posted: 02 Sep 2019 20:58

zag
Posts: 1,558
Joined: Oct 2016

As requested earlier I have now added a database field for dateEventLocal. This generally used for USA events that start late at night.

It's editable like any other data from the "Edit Event" button.

EDIT: If anyone wants to test it out, the NFL season is a bit messed up as its currently using local USA times.

https://www.thesportsdb.com/season.php?l=4391&s=2019

I may take a look at this at a later date, If I find a UTC source for the dates/times of NFL matches.


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 7 (Total: 7)