timestamp - AWS 雅典娜 SYNTAX_ERROR : not a valid timestamp literal

Question

我正在尝试运行以下查询:

SELECT startDate
FROM tests
WHERE startDate
    BETWEEN TIMESTAMP '1555248497'
        AND TIMESTAMP '1555248498' limit 10;

并不断收到此错误消息:

**"SYNTAX_ERROR: line 4:13: '1555248497' is not a valid timestamp literal"**

我还尝试删除时间戳周围的引号，但出现以下错误:

line 4:23: extraneous input '1555248497' expecting {'.', '[', 'at', 'and', '+', '-', '*', '/', '%', '||'} (service: amazonathena; status code: 400; error code: invalidrequestexception; request id: 44ad270d-54e4-442b-8b1a-93a6b6eba9ac)

“startedDateTime”列的类型是“timestamp”。

如何将时间戳值转换为有效的时间戳文字？

Answer 1

timestamp literals是这样的形式:

TIMESTAMP '2001-08-22 03:04:05.321'

要将 UNIX 时间戳(自 1970-01-01 00:00 UTC 以来的秒数)转换为 timestamp 数据类型，请使用 from_unixtime .