interval conversion - Mailing list pgsql-sql

From Brett Dikeman
Subject interval conversion
Date
Msg-id 61031.63.142.161.101.1062077015.squirrel@frank.mercea.net
Whole thread Raw
Responses Re: interval conversion  (Tomasz Myrta <jasiek@klaster.net>)
List 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock row in table
Next
From: Tomasz Myrta
Date:
Subject: Re: interval conversion