interval conversion

From: "Brett Dikeman" <brett(at)cloud9(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: interval conversion
Date: 2003-08-28 13:23:35
Message-ID: 61031.63.142.161.101.1062077015.squirrel@frank.mercea.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello all!

I have a possibly stupid question- I'm doing some time calculations yielding
intervals, and for my purposes I need to convert the interval(say, "1 day 8
hours") into (floating point) hours. While there's a plethora of handy
date_extract functionality and the like, I need a conversion.

Any suggestions on how to accompish this? Simpler the better, of course.

Thanks!

Brett

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-08-28 13:38:33 Re: lock row in table
Previous Message Daniel 2003-08-28 12:14:38 Re: lock row in table