| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: "Delta" or "elapsed" time column in Oracle
Bill McLaughlin wrote:
> Thanks to both of you for the info. I ended up using the INTERVAL DAY
> TO SECOND to store the data. I hope I made the right choice. Now my
> main problem is using this column in calculations. It's easy to select
> based on interval ranges, but I am having difficult using other
> functions (like mean and average) as they are expecting numeric
> values. I am going through the SQL reference to find the solution.
> However, if anyone can point me to any specific documentation or
> examples I'd appreciate it.
Now you know why I didn't recommend INTERVAL DAY TO SECOND. :)
Also: Are you planning on using JDBC to access this table? The JDBC drivers don't support the INTERVAL data types very well.
David Rolfe
Orinda Software
Dublin, Ireland
 |
 |