Site
Home / Forum / Developers / How timezone is used ?

How timezone is used ?


Posted: 10 Sep 2018 20:22

zag

Posts: 3,367
Joined: 2020

Hi,

I've a problem, i suppose time of each game is in UTC but when i convert into Toronto timezone, some time's games are wrong and some are correct.

Do you have an idea ?

I try whit NFL game : New York Jets @ Detroit Lions, i get 7:50pm after conversion but it's 7:10pm in fact.

Sorry for my english, i'm french

Posted: 13 Sep 2018 10:29

zag

Posts: 3,367
Joined: 2020

No problem, time zones are a bit up in the air at the moment.

There is no standard, and people are entering them both with UTC and local times zones. I really need to fix this just unsure what would be best. Perhaps a separate DB field for UTC time?

EDIT: NFL games are currently entered by the site users manually so can be anything really.

Posted: 11 May 2019 00:12

zag

Posts: 3,367
Joined: 2020

Has this been solved yet?
I see MLB and MLS's strTime is not correct.
For example, MLB's Houston Astros vs Texas Rangers's strTime is 01:10 (2019-05-11)
but it was actually started at 00:10.

https://www.thesportsdb.com/api/v1/json ... 05-11&lmlb

Posted: 11 May 2019 08:28

zag

Posts: 3,367
Joined: 2020

All times are UTC +1 as we're currently on summer period

Posted: 11 May 2019 08:41

zag

Posts: 3,367
Joined: 2020

Yes unfortunately this is just a data thing. The source I imported MLB baseball from was a GMT timing which is a bit annoying I know for US users as sometimes the date can also be different.

You are welcome to go in and change the dates or times especially on US sports. But at the moment its probably best to use the GMT + 1 for the timezone.

I really need to work out hows best to do this, or find better data sources. NFL for example is all USA timezone as I entered that manually.

NOTE: I have introduced a new field in events called datetimeEventUTC for the future but at the moment it is unused. If anyone knows a source of event data that uses UTC times that would be great. So far I have not found it though.


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