Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

AWS Timestream convert HEX string

0

Hi,

Is there a way to convert a hex string to an INT in AWS timestream? I cant find any functions that are supported to do this.

Thanks!

Mike

Topics
Database
Tags
Amazon Timestream
Language
English
asked 3 years ago444 views
1 Answer
1
Accepted Answer

Hi Mike, there are conversion functions available depending on your hex size:

select from_big_endian_64(from_hex('00000000DEEDDEED')) or select from_big_endian_32(from_hex(‘DEEDDEED’))

AWS
SUPPORT ENGINEER
answered 3 years ago

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.

Relevant content