Kayako logo
Developers & Code Interested in customizing your Kayako products? Discuss modifications and develop your own mods with the community.

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  (#1) Old
jamesM Offline
Member
 
Posts: 51
Join Date: Jun 2006
SQL query to show response time in minutes - 23-09-2006, 12:04 AM

I am not so hot when it comes to MYSQL querys could some one help me write a query to get the response time and also to show how long a support case stays open eg until its closed I am trying to get this in minutes at the moment I keep getting a funny time format I will try and post up my current query a little later to show you how I am trying to do it.
   
Reply With Quote
Reply

Tags
minutes, query, response, sql

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Average response time for a department JamesSmith SupportSuite, eSupport and LiveResponse 0 18-02-2007 05:14 PM
Report - SQL Query Help! sureshkumar.mr SupportSuite, eSupport and LiveResponse 0 28-09-2006 04:24 PM



Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46