sql jam masuk kelaur

on



select
EmpNo,
day(date) AS `Date`,
dayname(date) AS `Day`,
year(date) AS `year`,
`date` AS date1,
timein,
timeout,
if((TIMEDIFF(timein,"08.00"))>"00.00),0)", (TIMEDIFF(timein,"08.00")), 0) AS Late,
if((TIMEDIFF(timeout,"16.00"))>"00.00", (TIMEDIFF(timeout,"16.00")), 0) AS Overtime,
timetotal
FROM timing

Comments

Post a Comment