error date_part
Reportula is a php based web program that provides you a summarized ou
Status: Beta
Brought to you by:
oliveiraped
Menu
▾
▴
#7 error date_part
open
nobody
None
2014-07-09
2014-07-09
Anonymous
No
Originally created by: chevallierIDM
Did you tell me what should be HOURSDIFF format (output of the SQL request) in :
select (date_part('hour', (max(starttime) - min(starttime))) + (date_part('minutes', (max(starttime) - min(starttime))) / 60.0)) AS hoursdiff from Job where starttime >= 2014-07-07 18:29 and endtime <= 2014-07-08 18:29)
and hoursbytes in :
select(DB::raw("(sum(jobbytes)/(date_part('hour', (max(starttime) - min(starttime))) + (date_part('minutes', (max(starttime) - min(starttime))) / 60.0))) AS hoursbytes"))
Related
