Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

TimeStream and time zones

0

I have IoT things sending timestamps in GMT to a TimeStream table. This means that the data is corrected to GMT no matter where the data was collected. Are there time zone shift functions that I am missing? The only thing I can find (and works OK) is using time - 5h.

Are there any functions that correct based on an actual timezone?

Themen
Datenbank
Tags
Amazon Timestream
Sprache
English
flycast
gefragt vor 2 Jahren1203 Aufrufe
1 Antwort
1

Hi

Currently, timestream does not support Timezone. The only way available if the input time different from UTC is to add or subtract to offset before input into table.

AWS
SUPPORT-TECHNIKER
Kevin_Z
beantwortet vor 2 Jahren
  • Igor Ozerskii
    vor 10 Monaten

    Can you please clarify how actually that works?

    Because if I simply add +1 Hour (3600 sec) to UTC timestamp, I received that

    "RejectedRecords":[{"Reason":"The record timestamp is outside the time range [2023-06-19T03:15:36.657Z, 2023-06-29T15:55:36.657Z) of the data ingestion window.","RecordIndex":0}]}'

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt