需要执行这个语句:
SELECT TIMEPOINT from "dbo"."TB_HOURSDATA"
where
1=1
<if test="stationId !=null and stationId !=''">
AND STATIONID = #{stationId}
</if>
AND TIMEPOINT <= now() - interval '20 minutes'
ORDER BY TIMEPOINT DESC
LIMIT 1 OFFSET 0
虽然数据是查出来了,但是now() - interval '20 minutes'这里报错了
求会的人指点一下这个语句怎么修改
now() - interval '20 minutes' 这样没问题的。具体报错信息是什么?而且报错的话还能查出来数据?这有问题啊。