time difference

From: q u a d r a <quadratini(at)sni(dot)ph>
To: pgsql-sql(at)postgresql(dot)org
Subject: time difference
Date: 2002-06-28 03:58:39
Message-ID: 3D1BDEEF.50409@sni.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-06-28 06:08:51 Re: transaction in plpgsql
Previous Message Tom Lane 2002-06-28 03:52:40 Re: 2 Selects 1 is faster, why?