Different types compared

Content

Values ​​of different types cannot be compared

How to Slove

  • convert the type to the same

FP Console Output

Cannot apply operator: date >varchar

Example Code

block_timestamp>'2021-01-01' 

should change to :

block_timestamp>timestamp '2021-01-01'