Difference between local time and "created_at

It would be expected that times in that format would be converted to be in timezone UTC. To plot them in local time, you would need to change the TimeZone property of the data.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

noone Me 2024-8-22

Thanks Walter but I don't know where to change the topic to read "2024-08-21T16:54:31:+02.00".

请先登录，再进行评论。

Answer 2

Star Strider 2024-8-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2146964-difference-between-local-time-and-created_at#answer_1502824

在 MATLAB Online 中打开

To illustratte —

TZ = timezones("Europe");
disp(TZ)
             Name              Area     UTCOffset    DSTOffset
    ______________________    ______    _________    _________

    {'Europe/Amsterdam'  }    Europe        1            1    
    {'Europe/Andorra'    }    Europe        1            1    
    {'Europe/Astrakhan'  }    Europe        4            0    
    {'Europe/Athens'     }    Europe        2            1    
    {'Europe/Belgrade'   }    Europe        1            1    
    {'Europe/Berlin'     }    Europe        1            1    
    {'Europe/Bratislava' }    Europe        1            1    
    {'Europe/Brussels'   }    Europe        1            1    
    {'Europe/Bucharest'  }    Europe        2            1    
    {'Europe/Budapest'   }    Europe        1            1    
    {'Europe/Busingen'   }    Europe        1            1    
    {'Europe/Chisinau'   }    Europe        2            1    
    {'Europe/Copenhagen' }    Europe        1            1    
    {'Europe/Dublin'     }    Europe        0            1    
    {'Europe/Gibraltar'  }    Europe        1            1    
    {'Europe/Guernsey'   }    Europe        0            1    
    {'Europe/Helsinki'   }    Europe        2            1    
    {'Europe/Isle_of_Man'}    Europe        0            1    
    {'Europe/Istanbul'   }    Europe        3            0    
    {'Europe/Jersey'     }    Europe        0            1    
    {'Europe/Kaliningrad'}    Europe        2            0    
    {'Europe/Kiev'       }    Europe        2            1    
    {'Europe/Kirov'      }    Europe        3            0    
    {'Europe/Lisbon'     }    Europe        0            1    
    {'Europe/Ljubljana'  }    Europe        1            1    
    {'Europe/London'     }    Europe        0            1    
    {'Europe/Luxembourg' }    Europe        1            1    
    {'Europe/Madrid'     }    Europe        1            1    
    {'Europe/Malta'      }    Europe        1            1    
    {'Europe/Mariehamn'  }    Europe        2            1    
    {'Europe/Minsk'      }    Europe        3            0    
    {'Europe/Monaco'     }    Europe        1            1    
    {'Europe/Moscow'     }    Europe        3            0    
    {'Europe/Oslo'       }    Europe        1            1    
    {'Europe/Paris'      }    Europe        1            1    
    {'Europe/Podgorica'  }    Europe        1            1    
    {'Europe/Prague'     }    Europe        1            1    
    {'Europe/Riga'       }    Europe        2            1    
    {'Europe/Rome'       }    Europe        1            1    
    {'Europe/Samara'     }    Europe        4            0    
    {'Europe/San_Marino' }    Europe        1            1    
    {'Europe/Sarajevo'   }    Europe        1            1    
    {'Europe/Saratov'    }    Europe        4            0    
    {'Europe/Simferopol' }    Europe        3            0    
    {'Europe/Skopje'     }    Europe        1            1    
    {'Europe/Sofia'      }    Europe        2            1    
    {'Europe/Stockholm'  }    Europe        1            1    
    {'Europe/Tallinn'    }    Europe        2            1    
    {'Europe/Tirane'     }    Europe        1            1    
    {'Europe/Ulyanovsk'  }    Europe        4            0    
    {'Europe/Uzhgorod'   }    Europe        2            1    
    {'Europe/Vaduz'      }    Europe        1            1    
    {'Europe/Vatican'    }    Europe        1            1    
    {'Europe/Vienna'     }    Europe        1            1    
    {'Europe/Vilnius'    }    Europe        2            1    
    {'Europe/Volgograd'  }    Europe        3            0    
    {'Europe/Warsaw'     }    Europe        1            1    
    {'Europe/Zagreb'     }    Europe        1            1    
    {'Europe/Zaporozhye' }    Europe        2            1    
    {'Europe/Zurich'     }    Europe        1            1    
MessageTime = datetime("2024-08-21T16:54:31Z", 'InputFormat','yyyy-MM-dd''T''HH:mm:ssZ', 'TimeZone','Europe/Paris')
MessageTime = datetime
   21-Aug-2024 18:54:31

.

4 个评论
显示 2更早的评论隐藏 2更早的评论

noone Me 2024-8-22

RE..

I'm sorry (thanks again for your help) but I don't know where to put the "MessageTime" that you programmed for me. I'm new to ThingSpeack and the topic I've received is as follows:

13:48:15.884 -> Message arrived from the topic: channels/2499901/subscribe

13:48:15.884 -> Message:{"channel_id":2499901,"created_at":"2024-08-22T11:48:14Z","entry_id":34325,"field1":"34.10","field2":"34.40","field3":"69","field4":"27.81","field5":null,"field6":null,"field7":null,"field8":null,"latitude":null,"longitude":null,"elevation":null,"status":null}

Where can I take action to change the "created_at" please ?

Star Strider 2024-8-22

在 MATLAB Online 中打开

I have no experience with ThingSpeak.

One option —

dts = extractBetween('{"channel_id":2499901,"created_at":"2024-08-22T11:48:14Z","entry_id":34325,"field1":"34.10","field2":"34.40","field3":"69","field4":"27.81","field5":null,"field6":null,"field7":null,"field8":null,"latitude":null,"longitude":null,"elevation":null,"status":null}', '"created_at":',',')
dts = 1x1 cell array
    {'"2024-08-22T11:48:14Z"'}
MessageTime = datetime(dts{:}, 'InputFormat','"yyyy-MM-dd''T''HH:mm:ssZ"', 'TimeZone','Europe/Paris')
MessageTime = datetime
   22-Aug-2024 13:48:14

I am not certain how to extract that particular information (the Message cell array to use in the extractBetween call) from whatever ThingSpeak returns, however if you can do that, this approach should work.

.

请先登录，再进行评论。