From: Brett Dikeman <brett@cloud9.net>
To: pgsql-sql@postgresql.org
Subject: interval conversion
Date: Thu, 28 Aug 2003 09:23:35 -0400 (EDT)
Message-ID: <61031.63.142.161.101.1062077015.squirrel@frank.mercea.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: brett@cloud9.net
Subject: Re: interval conversion
In-Reply-To: <61031.63.142.161.101.1062077015.squirrel@frank.mercea.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox