Site
Home / Forum / Developers / MLB strTime format

MLB strTime format


Posted: 19 Mar 2018 20:52

kkagill
Posts: 9
Joined: Jan 2018

Hi, thanks for importing MLB matches.
FYI, strTime on 2018-03-18 (12:05) and 2018-03-31 (17:45:00) are different.

Can this be not changed? I think it needs to be consistent with the UTC format (17:45:00)

https://www.thesportsdb.com/api/v1/json ... 3-18&l=mlb
https://www.thesportsdb.com/api/v1/json ... 3-31&l=mlb

Thanks!

Posted: 19 Mar 2018 22:00

zag
Posts: 1,558
Joined: Oct 2016

Yeh the times are a mess at the moment, I agree it should be standardized on UTC then clients can adjust as they wish.

Just a shame all the API's i've used are totally different formats!

I will take a look what can be done with some php datetime() magic

Posted: 19 Mar 2018 23:56

edalex
Posts: 88
Joined: Mar 2017

And probably date should be local as I stated previously

Posted: 31 Mar 2018 11:46

edalex
Posts: 88
Joined: Mar 2017

zag, I believe all date+time from MLB API (and NHL too) should be converted from UTC to Eastern Time since MLB and NHL sites have ET.

Posted: 01 Apr 2018 23:16

zag
Posts: 1,558
Joined: Oct 2016

Yep hopefully should be able to look at this tomorrow, I will create a new local time and UTC time fields

Posted: 02 Apr 2018 17:41

edalex
Posts: 88
Joined: Mar 2017

Yep hopefully should be able to look at this tomorrow, I will create a new local time and UTC time fields
Cool! and don't forget about deleting Spring Trainings


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)