By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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?

Topics
Database
Tags
Amazon Timestream
Language
English
flycast
asked 2 years ago1185 views
1 Answer
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 ENGINEER
Kevin_Z
answered 2 years ago
  • Igor Ozerskii
    10 months ago

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

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content