hi guys,very new here, so hello!
Right i have a problem; I have a db which holds data on incoming calls for my company. I have to create a report for a meeting, which will logg all the calls, and im trying to use sql as a quick way to get to the information. I have to list all the calls logged and new call issues, and existing calls. I have already logged the calls between the dates 05/04/2003 00:00:00' AND '05/09/2003 23:59:59' (US time), but I have to separate the calls between new issues and calls logged?
I logged the calls with this statement
SELECT *
FROM Issue
WHERE (IssueReported BETWEEN '05/04/2003 00:00:00' AND '05/09/2003 23:59:59')
IssueReported is a column, which holds both time and data, is there was way I can use some sort of operator to count the number of minutes the call was for, so this would go into New Issue?
I know this sounds really compacted, it is, that’s why I need you guys to help me xx🙂
