Archives of the TeradataForum

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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	Next>	Last>>