TimeStream and time zones

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?

トピック

データベース

タグ

Amazon Timestream

言語

English

flycast

質問済み 2年前1202ビュー

1回答

新しい順
投票が多い順
コメントが多い順

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.

サポートエンジニア

Kevin_Z

回答済み 2年前

Igor Ozerskii
10ヶ月前
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}]}'

TimeStream and time zones

関連するコンテンツ