AVG and SUM for INTERVALs
Presumably due to an oversight, Oracle have not yet overloaded the SUM and AVG functions to support the INTERVAL DAY TO SECOND datatype. Here are my AVG_DSINTERVAL and SUM_DSINTERVAL aggregate/analytic functions.
William Robertson http://www.williamrobertson.net/code/agg_dsinterval.typ.txt
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Index of code examples