Skip to content

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

asked 4 years ago981 views

1 Answer
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
AWS

answered 4 years ago

AWS
EXPERT

reviewed 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.