select * from dev.table_Meeting where
Meeting_ID = 22
AND
trunc(trunc(to_date(Meeting_Start_Time)) - trunc(to_date(sysdate))) = 1文字与格式字符串格式不匹配
Meeting_ID = 22
AND
trunc(trunc(to_date(Meeting_Start_Time)) - trunc(to_date(sysdate))) = 1文字与格式字符串格式不匹配
Meeting_ID = 22
AND
trunc(trunc(to_date(Meeting_Start_Time)) - trunc(to_date(sysdate))) = 1好多问题啊、。to_date 好歹得指明按照什么格式转换为日期
sysdate 还有必要to_date么?
可用
select * from dev.table_Meeting
where Meeting_ID = 22
AND trunc(Meeting_Start_Time) - trunc(sysdate) = 1
如果为varchar2
可用
select * from dev.table_Meeting
where Meeting_ID = 22
AND trunc(TO_DATE(Meeting_Start_Time,'YYYY-MM-DD')) - trunc(sysdate) = 1
你的语句写的太不好了。