SQL - phpmyadmin average time

I am working with a joomla helpdesk component (Huruhelpdesk) and i need to work a query to see the average time of the tickets since the user open the ticket (start_date) till the reps close the ticket (close_date) for the purpose of reports. But like i said i am not a programmer i am in my baby steps. Can anybody help or point me in any way on how to accomplish this??

The table shows the start_date column, the close_date column, the rep column, category column and department column.

This question and answers originated from www.stackoverflow.com
Question by (10/6/2011 3:41:56 PM)

Answer

Unfortunately there is no answer yet for this question ...

Find More Answers
Related Topics  sql  query  phpmyadmin  reports  average
Related Questions

  • Mysql Average on time column?

    SELECT avg( duration ) as average FROM `login`; The datatype for duration is "time", thus my value is like: 00:00:14, 00:20:23 etc I execute the query it gives me: 2725.78947368421 What is…

  • Java Time Specific Average

    I have a text file: DATE 20090105 1 2.25 1.5 3 3.6 0.099 4 3.6 0.150 6 3.6 0.099 8 3.65 0.0499 DATE 20090105 DATE 20090106 1 2.4 1.40 2 3.0 0.5 5 3.3 0.19 7 2.75 0.5 10 2.75 0.25 DATE 20090106 DA…

  • Average Time to Reply to Message

    Is it possible to calculate the average time to reply to a message just with the following columns: id | ref | client | admin | date | message id is the unique message number ref is the m…

  • Query to calculate average time between successive events

    My question is about how to write an SQL query to calculate the average time between successive events. I have a small table: event Name | Time stage 1 | 10:01 stage 2 | 10:03 stage…

  • SQL AVERAGE TIME

    I have the following query in MSSQL: select TRANSACTION_TYPE_ID ,COUNT(TRANSACTION_TYPE_ID)AS NUMBER_OF_TRANSACTIONS ,CAST(SUM(AMOUNT)AS DECIMAL (30,2)) AS TOTAL FROM [ONLINE_TRANSACTION] WH…

  • SQL Compute Average of Two Fields

    I have a database table which has three relevant fields, firstly a user id, then one is a number of submitted nodes, the other is a sum of the "score" for each node. I need to be able to run a qu…

  • SQL Work out the average time difference between total rows

    I've searched around SO and can't seem to find a question with an answer that works fine for me. I have a table with almost 2 million rows in, and each row has a MySQL Date formatted field. I'd l…

  • Taking the time average of the product of two waves

    How might one go about calculating the time average of the product of two identical waves with different phases? For example, what would be the time average of: $$ \cos(k x-w t) \cdot \cos(kx-wt+…

  • How to average time intervals?

    In Oracle 10g I have a table that holds timestamps showing how long certain operations took. It has two timestamp fields: starttime and endtime. I want to find averages of the durations given by the…

  • SQL Query to get Average time

    I have 4 columns in my database UserName, Date, Time, LoginType UserName is a varchar field Date is a date field Time is a time field (in 24 hour format) LoginType is a varchar field Login…