Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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?

Argomenti
Database
Tag
Amazon Timestream
Lingua
English
flycast
posta 2 anni fa1203 visualizzazioni
1 Risposta
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
TECNICO DI SUPPORTO
Kevin_Z
con risposta 2 anni fa
  • Igor Ozerskii
    10 mesi fa

    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}]}'

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente