level 1
单向度蓝WT
楼主
SELECT * FROM (select A.FMSNAME,B.FNAME,A.FBILLID,A.fedittime,A.FDESC,A.FSTATENAME,A.FSUBTIME,A.FDETIME,getdate(),
dbo.kydatediff('hh',A.FDETIME,A.FSUBTIME) as cq
FROM EAM_BUG A
LEFT join EAM_BUGCLASS B on B.FGUID=A.FCLASS)
WHERE ((dbo.kydatediff('hh',FDETIME,FSUBTIME)>24 and FNAME='测试1')or(dbo.kydatediff('hh',FDETIME,FSUBTIME)>72 and FNAME='测试2'))
and FSUBTIME is not null
and FDETIME is not null
and FSUBTIME>=dbo.kyformatdate('2016-06-01','yyyy-MM-dd')
2017年02月22日 03点02分
1
dbo.kydatediff('hh',A.FDETIME,A.FSUBTIME) as cq
FROM EAM_BUG A
LEFT join EAM_BUGCLASS B on B.FGUID=A.FCLASS)
WHERE ((dbo.kydatediff('hh',FDETIME,FSUBTIME)>24 and FNAME='测试1')or(dbo.kydatediff('hh',FDETIME,FSUBTIME)>72 and FNAME='测试2'))
and FSUBTIME is not null
and FDETIME is not null
and FSUBTIME>=dbo.kyformatdate('2016-06-01','yyyy-MM-dd')