Home > mailing lists

Re: Convert INT to INTERVAL? - Mailing list pgsql-sql

From	Stephan Szabo
Subject	Re: Convert INT to INTERVAL?
Date	February 27, 2004 16:28:05
Msg-id	20040227092735.N87097@megazone.bigpanda.com Whole thread Raw
In response to	Convert INT to INTERVAL? (Brian Knox <laotse@aol.net>)
List	pgsql-sql

Tree view

On Fri, 27 Feb 2004, Brian Knox wrote:

> Is it possible within pl/pgsql, to convert an integer to an interval in
> months? IE, if num_months is an INT set to 48, can it be converted to an
> interval?

You should be able to say something likenum_months * INTERVAL '1 month'
I believe.

pgsql-sql by date:

From: Brian Knox
Date: 27 February 2004, 15:54:23
Subject: Convert INT to INTERVAL?

From: "David"
Date: 27 February 2004, 16:29:38
Subject: Re: searching polygons

Re: Convert INT to INTERVAL? - Mailing list pgsql-sql

Previous

Next