Log In
Register
6:13 pm
December 16, 2018
Offline
Hi there, when I export the data that is being measured it always get 2 hours time difference. I am in Rio ( UTC +3) -1 hour for daylight saving time. How can I fix that? Thank you for you answer, Carolina
9:28 am
Moderators
March 7, 2017
Offline
You can use the timezone parameter for the Read data API
https://www.mathworks.com/help/thingspeak/readdata.html
The time zones are listed here.
https://www.mathworks.com/help/thingspeak/time-zones-reference.html
Here is an example for +3
http://api.thingspeak.com/channels/9/feeds.json?timezone=Europe/Kiev
I think Rio is -2 at present, based on DST.
http://api.thingspeak.com/channels/9/feeds.json?timezone=America/Godthab&results=1000
or for excel compatible data
http://api.thingspeak.com/channels/9/feeds.csv?timezone=America/Godthab&results=1000
You can get up to 8000 results this way. At present the export to excel does not provide the adjusted timestamp. If you need more than 8000 points, you can use the start and end parameters to set times and use multiple reads.
12:58 am
February 13, 2019
Offline
cstapels said
You can use the timezone parameter for the Read data API
https://www.mathworks.com/help/thingspeak/readdata.htmlThe time zones are listed here.
https://www.mathworks.com/help/thingspeak/time-zones-reference.htmlHere is an example for +3
http://api.thingspeak.com/channels/9/feeds.json?timezone=Europe/KievI think Rio is -2 at present, based on DST.
http://api.thingspeak.com/channels/9/feeds.json?timezone=America/Godthab&results=1000
or for excel compatible data
http://api.thingspeak.com/channels/9/feeds.csv?timezone=America/Godthab&results=1000You can get up to 8000 results this way. At present the export to excel does not provide the adjusted timestamp. If you need more than 8000 points, you can use the start and end parameters to set times and use multiple reads.
Maravilloso!
Thank!!
Most Users Ever Online: 166
Currently Online:
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
briskpanda, Dejw0089, Yassine Ben Salah, anis, 43994554AKS, sudaModerators: cstapels: 460
Administrators: Hans: 405, lee: 457
