Hi..
How could i calculate the different between 2 timestamp. please guide me ..
Below is my query:-
Code:
SELECT DISTINCT
c.job_kat AS "JOB",
CONCAT (c.target_sla_sdate, c.target_sla_stime) AS "SLA",
CONCAT (c.target_sla_edate, ' ', c.target_sla_etime) AS "ARAHAN",
TIMEDIFF(CONCAT (c.target_sla_sdate, ' ', c.target_sla_stime),
CONCAT (c.target_sla_edate, ' ', c.target_sla_etime)) AS "BEZA",
c.request_id
FROM customerjobrequest c JOIN jobrequest j ON c.JobTicketID = j.JobTicketID
JOIN packextra_trans p ON p.JobTicketID = j.ID
WHERE job_type LIKE "bill" AND data_filename LIKE "%01022010%"
GROUP BY c.request_id
ORDER BY p.JobTicketID;