Postgres Hours Calculation

Question

I have been trying to work this out all week. I have a table with values names start and finish. I need a Postgres query to relay the hours back to me in a nice format.

The original (before hours) query is this

select * from public.volass
where linkedass=$request_id 
order by start

So when I try and use DiffDate I make it look like

select datediff(hours,start,finish), * from public.volass
where linkedass=$request_id 
order by start

Postgres then gives me the following error.

ERROR:  column "hours" does not exist
LINE 1: select datediff(hours,start,finish), * from public.volass
                        ^
********** Error **********
ERROR: column "hours" does not exist
SQL state: 42703
Character: 17

Do I need to have a field named "Hours" in the system for this to work
Even if I add a field named "hours" it still stuffs up
Can you steer me in the correct direction to use Difdate

Parfait · Accepted Answer · 2016-03-27 21:44:46Z

1

Consider using Postgre's EXTRACT:

SELECT (EXTRACT(EPOCH FROM finish - start) / 3600) AS duration, *
FROM public.volass 
WHERE linkedass=$request_id 
ORDER BY start

edited Mar 27, 2016 at 21:44

answered Mar 27, 2016 at 21:38

Parfait

108k19 gold badges103 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres Hours Calculation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related