select * from USER_INFO where to_char(data,'yyyy/MM/dd')=to_char(sysdate-1,'yyyy/MM/dd')原文链接：https://www.f2er.com/oracle/213877.html
select * from USER_INFO where to_char(data,'yyyy/MM/dd')=to_char(sysdate-1,'yyyy/MM/dd')原文链接：https://www.f2er.com/oracle/213877.html
