| | Posted: 01 Feb 2019 19:22 | |
zag
Posts: 3,521
Joined: 2020
| | Hi,
I've been watching that some NBA games appear the day after they really happened. Maybe it has something to do with the game time and my time frame.
Sample:
https://www.thesportsdb.com/event/588098
https://es.global.nba.com/scores/#!/2018-12-31
| |
 |
| | Posted: 01 Feb 2019 20:00 | |
zag
Posts: 3,521
Joined: 2020
| | Hi,
This is because NBA games are entered on the DB using UTC times.
| |
|
| | Posted: 01 Feb 2019 20:50 | |
zag
Posts: 3,521
Joined: 2020
| | I guessed that, but can it be fixed?
| |
|
| | Posted: 03 Feb 2019 14:21 | |
zag
Posts: 3,521
Joined: 2020
| | Yeh I really need a solution to this, but not sure what to do as the only source I had for the schedual was a UK website which is in GMT or UTC time.
The solution I guess is to manually edit those games to standard USA dates. I think its only the evening matches that go over the mid night in GMT time.
I will have to think about a more permanent solution for the next seasons import. Unless anyone knows of a US website that lists all the matches on a single page.
| |
|
| | Posted: 16 Feb 2019 03:18 | |
zag
Posts: 3,521
Joined: 2020
| | Yeh I really need a solution to this, but not sure what to do as the only source I had for the schedual was a UK website which is in GMT or UTC time.
The solution I guess is to manually edit those games to standard USA dates. I think its only the evening matches that go over the mid night in GMT time.
I will have to think about a more permanent solution for the next seasons import. Unless anyone knows of a US website that lists all the matches on a single page.
Best way is to have a UTC or ISO format date combined with time that way its easier to convert it to date and time of an specific timezone
Example: 2018-12-29T15:00:00Z
alternative way is to combine the existing Dateevent with strTime and at T in between and Z at the end
| |
|
| | Posted: 16 Feb 2019 08:46 | |
zag
Posts: 3,521
Joined: 2020
| | Currently is on that way, as NBA events are entered on UTC times & days
| |
|
| | Posted: 17 Feb 2019 10:29 | |
zag
Posts: 3,521
Joined: 2020
| | Yeh I think we need to find a standard way to any developer can just translate from UTC easily.
| |
|