Formatting time as a unix timestamp

We are able to enter records into tables using any time unit. But when querying the table, I can only seem to be able to return it as what I can assume is the ISO format. IE: 2021-03-18 04:00:00.055000000

Is there any way to get a query result with a unix like timestamp instead?

主題

資料庫

標籤

Amazon Timestream

語言

English

DrBomb

已提問 3 年前檢視次數 738 次

2 個答案

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

已接受的答案

You can use the to_unixtime() function on the timestamp to convert to unix time e.g. select to_unixtime('2021-03-18 04:00:00.055000000')

Rajesh Iyer - AWS

已回答 3 年前

Thank you, this worked. Any reason why this function is not documented? I don't see it anywhere on the AWS Timestream docs.

DrBomb

已回答 3 年前

Formatting time as a unix timestamp

相關內容