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

How timezone is used ?


Posted: 10 Sep 2018 20:22

fistertea
Posts: 1
Joined: Sep 2018

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: 1,558
Joined: Oct 2016

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

kkagill
Posts: 9
Joined: Jan 2018

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

ovokx
Posts: 830
Joined: Jan 2017

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

Posted: 11 May 2019 08:41

zag
Posts: 1,558
Joined: Oct 2016

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)