将时间格式化为Unix时间戳

0

【以下的问题经过翻译处理】我们可以使用任何时间单位来将记录输入表中。但是当查询表时，我似乎只能将其返回为我可以认为是ISO格式的方式。例如：2021-03-18 04:00:00.055000000。

是否有办法以Unix时间戳的形式获取查询结果？

Topics

Tags

Amazon Timestream

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 8 months ago15 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

【以下的回答经过翻译处理】你可以使用to_unixtime()函数将时间戳转换成UNIX时间，例如：select to_unixtime('2021-03-18 04:00:00.055000000')。

EXPERT

rePost Polyglot

answered 8 months ago

Relevant content

我使用Codestar部署springboot项目，在Deploy的时候，使用template.yml创建EBEnvironment失败
rePost-User-1988868
asked a year ago
S3上无法使用Chunked上传文件｜ Unable to use Chunked to upload files on S3
rePost-User-1798329
asked a year ago
sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
Sites on Amplify become very slow recently. Amplify站点最近突然变得很慢。
Zhu
asked 10 months ago
How do I list KMS key grants and principals by Region in AWS KMS?
AWS OFFICIALUpdated 6 months ago
Where can I find SSH login credentials so that I can connect to my Lightsail instance from an SSH client?
AWS OFFICIALUpdated 11 days ago
How can I troubleshoot a deployment failure for an AWS IoT Greengrass component that runs a Docker container?
AWS OFFICIALUpdated a year ago
How do I troubleshoot "permission denied" or "unable to import module" errors when I upload a Lambda deployment package?
AWS OFFICIALUpdated 5 months ago
AWS IoT Device Client UDS sensor example
EXPERT
Kai Dickman
published 10 months ago
Automated S3 Content Library Indexing with AWS Lambda
EXPERT
Patrick Kremer
published a year ago