Wrong time when exporting data

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.

Wrong time when exporting data

December 16, 2018
6:13 pm

carolina

New Member

Members

Forum Posts: 1

Member Since:
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

January 15, 2019
9:28 am

cstapels

Moderator

Members

Moderators

Forum Posts: 885

Member Since:
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.

February 14, 2019
12:58 am

johnelectric

New Member

Members

Forum Posts: 1

Member Since:
February 13, 2019

Offline

cstapels said

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.

Maravilloso!
Thank!!

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
25 Guest(s)

Currently Browsing this Page:
1 Guest(s)