英文:
Convert date in DynamoDB from unix format using PartiQL
问题
我正在尝试使用PartiQL的新AWS功能从DynamoDB中选择数据。我注意到日期变量在DynamoDB中以Unix格式存储。然而，我想将它转换成人类可读的格式，比如GMT。
我已经尝试了下面的表达式，但它不起作用，给了我一个错误：
SELECT num_id, Date(last_activity_time)
FROM "cc-our-table"
是否有其他解决方案来将它转换为GMT？
英文:
I am trying to select data from DynamoDB using the PartiQL new AWS feature. I have noticed that the date variable is stored in Unix format in Dynamodb. However, I want to convert it into human readable format such as GMT.
I have used the next expression but it does not work, it gave me an error
SELECT num_id, Date(last_activity_time)
FROM "cc-our-table"
Is there any other solution how to convert it into gmt
答案1
得分: 1
Unfortunately PartiQL doesn't provide the ability to cast values.
英文:
Unfortunately PartiQL doesn't provide the ability to cast values.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论