Archives of the TeradataForum

Message Posted: Wed, 03 Sep 2003 @ 13:21:32 GMT

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

You can do conversions like this:

sel runname,qryname,sum(timeinsecs)/count(*) as avgtime, avgtime/3600 as timehours
,(avgtime-(3600*timehours))/60 as timeminutes
,avgtime-((3600*timehours)+60*timeminutes) as timeseconds
,trim(timehours)||':'||trim(timeminutes)||':'||trim(timeseconds) as averagetime

from results

group by 1,2
order by 1,2

Regards,

Jim

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