我写的sql语句如下：select NODE,NODEALIAS,SUMMARY,LASTOCCURRENCE,TALLY from REPORTER_STATUS where LASTOCCURRENCE >= current date - 7 days那位大侠能帮我看看哪里有问题。我运行的时候提示：SQL0401N The data types of the operands for the operation "...显示全部
我写的sql语句如下： select NODE,NODEALIAS,SUMMARY,LASTOCCURRENCE,TALLY from REPORTER_STATUS where LASTOCCURRENCE >= current date - 7 days 那位大侠能帮我看看哪里有问题。 我运行的时候提示： SQL0401N The data types of the operands for the operation ">=" are not compatible. SQLSTATE=42818收起