Matt, I am just taking a random whack at this, but could it be that those records don't have the date information your looking for and as such, are displaying the time since January 1st, 1970?
Not sure if that has anything to do with it, but something you might look into. Brian On Tue, Apr 1, 2008 at 1:01 PM, Gayford, Matthew C. <[EMAIL PROTECTED]> wrote: > ** > > List, > > > > I've been tasked with writing some reports to get the duration of time in > which tickets were open. We don't have SLM installed, so I decided that I > would report off of the Incident Assignment Log. Here's the query: > > > > SELECT Incident_Number, SUM(BusinessHoursDurationSeconds) AS > TimeOpen > > FROM HPD_Help_Desk_Assignment_Log > > GROUP BY Incident_Number > > ORDER BY TimeOpen DESC > > > > So everything was going well until I noticed some of the numbers appear > out of whack. For instance, there are a number of tickets where the > "business hours duration" field is 334939:53:44 and the "business hours > duration (sec)" field is 1205783624. Does anyone out there have any good > ideas on what could be going wrong here? TIA. > > > > -Matt > > > > *M*atthew *C*. *G*ayford > *T*echnology *R*esearch & *D*evelopment > *I*nformation *T*echnology *S*ystems *D*ivision > *U*niversity of *N*orth *C*arolina *W*ilmington > (910) 962-7177 > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
