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

0

The following shows the error above: abs(CAST(PZD.FILLED_CANCELLED_DATE AS INTEGER) - CAST(PZD.ORDER_DATE AS INTEGER) <= 9 ITEM 596 for my reference

Topics

Tags

Language

English

rePost-User-0008739

asked 2 years ago603 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

Accepted Answer

I think you're missing a closing parentheses. Try:

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

answered 2 years ago

EXPERT

reviewed 2 years ago

rePost-User-0008739
2 years ago
ok thank you vey much

Relevant content

BUG: describe_export_task PercentProgress seems rounded to the nearest integer, leading to 100% not necessarily meaning `COMPLETE`
rePost-User-1345006
asked 10 months ago
Lambda function error "list indices must be integers or slices, not str"
Accepted Answer
robbe
asked a year ago
GENERIC_INTERNAL_ERROR: integer overflow
Jorge Vidinha
asked a year ago
SYNTAX_ERROR: line 6:19: Unexpected parameters (timestamp, integer, integer) for function substr. Expected: substr(varchar(x), bigint, bigint)
rePost-User-0008739
asked 2 years ago
Why is my Reserved Instance showing as "Retired" in the console?
AWS OFFICIALUpdated 3 years ago
How do I resolve the "Last applied policy cannot be deleted" error in CloudFormation?
AWS OFFICIALUpdated 6 months ago
Why do accounts in my organization show as "suspended" in the AWS Organizations console?
AWS OFFICIALUpdated 3 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 to use the Python json module when decoding DynamoDB items
EXPERT
Brettski-AWS
published 7 months ago
Using CodeCatalyst to deploy Terraform Infrastructure as Code
EXPERT
Sundaresh_I
published 8 months ago