I need some help converting this statement to sql2k from Oracle as sql2k doesnt use floor etc.. P.duration and HEURE are my variables. Basically I'm trying to get my value for p.duration to be returned as hour:minute:second
Here is the Oracle statement:
'floor(sum(P.duration)/10/60/60) as HEURE,
'floor(sum(P.duration)/10/60) - floor(sum(P.duration)/10/60/60) * 60 as MINUTE,
'sum(P.duration)/10 - (floor(sum(P.duration)/10/60) - floor(sum(P.duration)/10/60/60) * 60 ) * 60 as SEC
Cheers,
Here is the Oracle statement:
'floor(sum(P.duration)/10/60/60) as HEURE,
'floor(sum(P.duration)/10/60) - floor(sum(P.duration)/10/60/60) * 60 as MINUTE,
'sum(P.duration)/10 - (floor(sum(P.duration)/10/60) - floor(sum(P.duration)/10/60/60) * 60 ) * 60 as SEC
Cheers,