Ask Your Question

Revision history  [back]

Revision 3
Ahmed Qasid's avatar
5.8k
Ahmed Qasid
updated 2018-12-05 04:32:50 +0200

تم إستخدام هذه المعادلة

select tl.fromDate,tl.fromTime,right('00'+cast(cast(((tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.fromTime+0.0)/3600000)-cast( (tl.fromTime+0.0)/3600000 as int))*60,0) as int) as varchar(2)),2) fTime
from TimeAttendanceLine tl


و قامت بالتالى
image description

إستعلام كامل لحساب الفرق أيضا:

select tl.fromDate,right('00'+cast(cast(((tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.fromTime+0.0)/3600000)-cast( (tl.fromTime+0.0)/3600000 as int))*60,0) as int) as varchar(2)),2) fTime
      ,tl.toDate,right('00'+cast(cast(((tl.toTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.toTime+0.0)/3600000)-cast( (tl.toTime+0.0)/3600000 as int))*60,0) as int) as varchar(2)),2) tTime
      ,right('00'+cast(cast(((tl.toTime-tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.toTime-tl.fromTime+0.0)/3600000)-cast( (tl.toTime-tl.fromTime+0.0)/3600000 as int))*60,0) as int) as varchar(2)),2) spentTime
from TimeAttendanceLine tl
Revision 2
Abdelrahman's avatar
101
Abdelrahman
updated 2018-12-04 02:25:57 +0200

تم إستخدام هذه المعادلة

select tl.fromDate,tl.fromTime,right('00'+cast(cast(((tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.fromTime+0.0)/3600000)-cast( (tl.fromTime+0.0)/3600000 as int))*60,0) int))60,0) as int) as varchar(2)),2) fTime
from TimeAttendanceLine tl
tl


و قامت بالتالى
image description

إستعلام كامل لحساب الفرق أيضا:

 
select tl.fromDate,right('00'+cast(cast(((tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.fromTime+0.0)/3600000)-cast( (tl.fromTime+0.0)/3600000 as int))*60,0) int))60,0) as int) as varchar(2)),2) fTime
      ,tl.toDate,right('00'+cast(cast(((tl.toTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.toTime+0.0)/3600000)-cast( (tl.toTime+0.0)/3600000 as int))*60,0) int))60,0) as int) as varchar(2)),2) tTime
      ,right('00'+cast(cast(((tl.toTime-tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.toTime-tl.fromTime+0.0)/3600000)-cast( (tl.toTime-tl.fromTime+0.0)/3600000 as int))*60,0) int))60,0) as int) as varchar(2)),2) spentTime
from TimeAttendanceLine tl
tl
Revision 1
Abdelrahman's avatar
101
Abdelrahman
answered 2018-12-04 02:14:38 +0200

تم إستخدام هذه المعادلة

select tl.fromDate,tl.fromTime,right('00'+cast(cast(((tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.fromTime+0.0)/3600000)-cast( (tl.fromTime+0.0)/3600000 as int))60,0) int))*60,0) as int) as varchar(2)),2) fTime from TimeAttendanceLine tl

و قامت بالتالى
image description

إستعلام كامل لحساب الفرق أيضا:
select tl.fromDate,right('00'+cast(cast(((tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.fromTime+0.0)/3600000)-cast( (tl.fromTime+0.0)/3600000 as int))60,0) as int) as varchar(2)),2) fTime ,tl.toDate,right('00'+cast(cast(((tl.toTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.toTime+0.0)/3600000)-cast( (tl.toTime+0.0)/3600000 as int))60,0) as int) as varchar(2)),2) tTime ,right('00'+cast(cast(((tl.toTime-tl.fromTime+0.0)/3600000) as int) as varchar(2)),2)+':'+right('00'+cast(cast(Round((((tl.toTime-tl.fromTime+0.0)/3600000)-cast( (tl.toTime-tl.fromTime+0.0)/3600000 as int))60,0) as int) as varchar(2)),2) spentTime from TimeAttendanceLine tl