Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 08 Jun 2002 @ 15:43:56 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Average Point in Time?
From:   Doug Drake

Assuming the interval in minutes is not exceptionally large to overflow you might consider taking the average of the difference in minutes between the min(endtime) and each endtime point and add this back to the min(endtime). It might be coded something similar to:

Min(endtime) + Avg((endtime-min(endtime))minute(4))

You might have to specify the second operand above with something a little different to indicate that it is an interval. I don't recall the exact syntax of the top of my head.

Hope this helps!

Doug Drake

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020