Skip to main content

In more detail,

 

ERROR

400: Comparison operator > (greater than) does not support comparing column {"case.table"."hired.full"] of type DATE] with constant of type CONST_INT]

 

The issue is that the "CONST_INT" is a DATETIME in the Datajobs so we don't understand this error. We are trying to compare two dates, and this error keeps falling in.

 

Any idea how to solve this problem?error 400

One of the dates is likely in the form of a string or in this case CONST_INT. You might have to use TO_DATE() to format.


Besides, the message seems to say that the Constant is of type INT ([CONST_INT])


Reply