error date_part

[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"))