Re: Howto turn an integer into an interval?

From: Erik Wasser <erik(dot)wasser(at)iquer(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Howto turn an integer into an interval?
Date: 2004-10-06 08:13:27
Message-ID: 200410061013.28369.erik.wasser@iquer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message sklassen 2004-10-06 15:19:11 Re: Database Backup
Previous Message Theo Galanakis 2004-10-06 05:44:13 Re: Regex