SYNTAX_ERROR: line 12:49: '<=' cannot be applied to interval day to second, integer

0

【以下的问题经过翻译处理】上述错误如下所示： abs(CAST(PZD.FILLED_CANCELLED_DATE AS INTEGER) - CAST(PZD.ORDER_DATE AS INTEGER) <= 9 我的参考物品编号为596。

Topics

Tags

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 5 months ago33 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

【以下的回答经过翻译处理】我认为你少了一个右括号。尝试：

abs(CAST(PZD.FILLED_CANCELLED_DATE AS INTEGER) - CAST(PZD.ORDER_DATE AS INTEGER)) <= 9

EXPERT

rePost Polyglot

answered 5 months ago

Relevant content

S3上无法使用Chunked上传文件｜ Unable to use Chunked to upload files on S3
rePost-User-1798329
asked a year ago
我通过Elastic Beanstalk创建环境之后，用code pipeline关联github中的springcloud项目deploy失败了，下面是具体报错原因
rePost-User-1988868
asked a year ago
sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
SYNTAX_ERROR: line 12:49: '<=' cannot be applied to interval day to second, integer
Accepted Answer
rePost-User-0008739
asked 2 years ago
How can I resolve the "Export EXPORT_NAME cannot be updated as it is in use by STACK_NAME" error in AWS CloudFormation?
AWS OFFICIALUpdated 2 years ago
How do I resolve the "Last applied policy cannot be deleted" error in CloudFormation?
AWS OFFICIALUpdated 6 months ago
Why isn't the lifecycle rule on my Amazon S3 bucket working even though I applied it more than one day ago?
AWS OFFICIALUpdated a year ago
How can I use partition projection to create CloudTrail tables for Athena queries?
AWS OFFICIALUpdated 3 months ago
Using CodeCatalyst to deploy Terraform Infrastructure as Code
EXPERT
Sundaresh_I
published 9 months ago
Using DynamoDB as an Append-Only Database
EXPERT
Leeroy Hannigan
published 7 months ago