[SQL] time difference

I have a query that returns ?column? - 6 days 01:56:14 (1 row) How can I get it as total number of hours? Instead of days and hours, I need hours only (all in all, so 24hours * 6 days + 01:56:14) Can you help me please? Thanks ---(end of bro

[SQL] graphical interface - admin

What's the best open source GUI for DB administration? (postgres) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html