select pr.logid,pr.siteid,pr.recodtime,po.dynamos,po.elecqty from productlog pr left outer join powerunits po on pr.logid=po.logid and pr.siteid=po.siteid where pr.recodtime between to_char(Trunc(sysdate,'month'),'yyyy-mm-dd') and to_char(sysdate,'yyyy-mm-dd');
为何时间要to_char? pr.recordtime是日期类型的吧
select pr.logid, pr.siteid, pr.recodtime, po.dynamos, po.elecqty from productlog pr left outer join powerunits po on pr.logid = po.logid and pr.siteid = po.siteid where pr.recodtime between to_char(Trunc(sysdate, 'month'), 'yyyy-mm-dd') and to_char(sysdate, 'yyyy-mm-dd'); --如果recodtime字段为日期型 文字与格式字符串不酝酿匹配
where pr.recodtime between to_char(Trunc(sysdate,'month'),'yyyy-mm-dd') and to_char(sysdate,'yyyy-mm-dd');
from productlog pr
left outer join powerunits po on pr.logid = po.logid
and pr.siteid = po.siteid
where pr.recodtime between to_char(Trunc(sysdate, 'month'), 'yyyy-mm-dd') and
to_char(sysdate, 'yyyy-mm-dd');
--如果recodtime字段为日期型 文字与格式字符串不酝酿匹配
日期可以直接使用 between and