Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Average Timestamps
From:   james e pricer

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



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