From: Michael Fuhr <mike@fuhr.org>
To: Terry Lee Tucker <terry@esc1.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Simple Question
Date: Tue, 11 Jan 2005 15:15:46 -0700
Message-ID: <20050111221545.GA9759@winnie.fuhr.org> (raw)
In-Reply-To: <200501111642.21716.terry@esc1.com>
References: <200501111642.21716.terry@esc1.com>
On Tue, Jan 11, 2005 at 04:42:21PM -0500, Terry Lee Tucker wrote:
> Subject: [SQL] Simple Question
Please use a more descriptive subject -- think about how somebody
looking at a list of 200 messages, all with subjects like "Simple
Question" or "PostgreSQL Question," would decide to look at yours.
> drv_time = 478 / 45.0;
>
> The value of this is: 10.6222222222222222
>
> Is there a way of converting this value to an interval. It seems that INTERVAL
> only works with a quoted literal value.
You can do arithmetic on intervals:
SELECT 478 / 45.0 * interval'1 hour';
For more information, see "Date/Time Functions and Operators" in
the documentation.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
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: mike@fuhr.org, terry@esc1.com
Subject: Re: Simple Question
In-Reply-To: <20050111221545.GA9759@winnie.fuhr.org>
* 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