Re: Howto turn an integer into an interval? - Mailing list pgsql-sql

From Erik Wasser
Subject Re: Howto turn an integer into an interval?
Date
Msg-id 200410061013.28369.erik.wasser@iquer.net
Whole thread Raw
In response to Re: Howto turn an integer into an interval?  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
On Tuesday 05 October 2004 13:44, you wrote:

> If you know for sure that you are keeping resend_interval in seconds,
> then try as follows:
>
> foodb=# SELECT (59::text||' secs')::interval;
>  interval
> ----------
>  00:00:59
> (1 row)


Thanks for this solution and the others. It's now working very fine. B-)

-- 
So long... Fuzz


pgsql-sql by date:

Previous
From: sad
Date:
Subject: Re: Howto turn an integer into an interval?
Next
From: sklassen@commandprompt.com
Date:
Subject: Re: Database Backup