现在我的sql是这样的

select

s.MACHINECODE SMT设备编码,

s.MACHINENAME SMT设备名称,

s.MACHINETYPE SMT设备类型,

s.MACHINESITECODE SMT设备站点编码,

s.MACHINESITENAME SMT设备站点名称,

s.FGCODEVERSION 物料型号编码,

s.DESCRIPTION 物料型号名称,

s.FGCODE 物料型号规格,

s.FGKIND 物料定制规格,

s.WORKORDER 工单编码,

s.BACKUP4 方案名称,

s.EVENTTIME 方案提取时间,

s.EVENTUSER 方案提取人,

i.MATERIALID 包装编码,

i.EVENTUSER 上料人,

i.EVENTTIME 上料时间，

i.EVENTNAME 操作事件,

i.FIXTURENAME 飞达名称，

i.BOXQTY 包装数量,

i.LASTQTY 包装现有数量,

u.USERNAME 操作人,

us.USERNAME 操作人2

from SMTLINKSITEMATHISTORY s join 

SMTSITEFIXMATUPHISTORY i on s.MACHINESITECODE=i.MACHINESITECODE

JOIN USERINFO u on s.EVENTUSER=u.USERID

JOIN USERINFO us on i.EVENTUSER=us.USERID

AND s.WORKORDER=i.BACKUP1 AND s.WORKORDERROW=i.BACKUP2

and s.EVENTTIME<=i.EVENTTIME

and to_char(trunc(s.EVENTTIME),'YYYY-MM-DD hh24:mi:ss')>='2021-10-13 15:13:32'

and to_char(trunc(s.EVENTTIME),'YYYY-MM-DD hh24:mi:ss')<='2021-10-14 15:13:32'

and to_char(trunc(i.EVENTTIME),'YYYY-MM-DD hh24:mi:ss')>='2021-10-13 15:13:32'

and to_char(trunc(i.EVENTTIME),'YYYY-MM-DD hh24:mi:ss')<='2021-10-14 15:13:32'

and s.BACKUP1 like'%SMT-1%'

and i.EVENTNAME like'%SMTMATUP%'

order by s.EVENTTIME desc

加了时分秒的那个格式  就差不到数据了