AWS re:Post Knowledge Center Feedback Survey

Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.

Transform a bigint to a duration in Timestream

When I have a bigint value which is actually a duration in milliseconds, is there a better way than this to transform it?

parse_duration(cast(my_value as varchar) || 'ms')

Topics: Database
Tags: Amazon Timestream
Language: English

rePost-User-5446241

asked 4 years ago394 views

1 Answer

Newest
Most votes
Most comments

This the correct way to transform a bigint value to duration in Timestream.

Rajesh Iyer - AWS

answered 4 years ago

Relevant content

ERROR: invalid input syntax for type bigint: "95139.81653861178"
rePost-User-4380538
asked 4 years ago
Saving data as Double instead of bigint
Accepted Answer
Morez
asked a year ago
Does Timestream have a function related to decoding base64 values?
Accepted Answer
Amante
asked 2 years ago
Join on bigint distkey column fails, but works when casting that bigint to varchar
wwitek
asked a month ago
How do I use pivoted data after an AWS Glue relationalize transformation?
AWS OFFICIALUpdated 4 years ago
How do I resolve the ThrottlingException error in Timestream for LiveAnalytics?
AWS OFFICIALUpdated 2 months ago
How do I use transformations in AWS DMS?
AWS OFFICIALUpdated 2 years ago
How can I troubleshoot Lambda Kinesis Firehose integration issues?
AWS OFFICIALUpdated 3 years ago
Transforming Redshift Super Data for DynamoDB Integration via AWS Glue
EXPERT
Monjumi
published a year ago
Migrating from on-prem Redis to Amazon DynamoDB
EXPERT
rsindreu
published 2 years ago

Transform a bigint to a duration in Timestream

Add your answer

Relevant content