XPost: comp.database.oracle   
   From: kennedy-downwithspammersfamily@attbi.net   
      
   "Ariant"  wrote in message   
   news:7a108ec3.0401151130.25b50118@posting.google.com...   
   > Hi -   
   >   
   > I'm trying to query my database to find the min, max and average times   
   > (in seconds, or minutes, or something) between two timestamps.  I've   
   > tried using:   
   >   
   > Select avg(timestamp1 - timestamp2) from table;   
   >   
   > I get an error saying that avg() expects a number, not an interval.   
   > Is there a way (in a SQL stmt) to convert timestamps (or their   
   > intervals, if they're different) so that I can run the avg, min, and   
   > max functions?   
   >   
   > I know that I could easily do this in C++ or Java, but I'm hoping to   
   > do all of my calculations in SQL statements, since they will be faster   
   > than in Java.   
   >   
   > Thanks!   
   > Ariant   
      
   Try the documentation.  If you subtract 1 o'clock from 2 o"clock what do you   
   get?  An interval of an hour!   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)