Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    18

    Unanswered: How could i calculate the different between 2 timestamp

    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;

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •