Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Convert INT to INTERVAL?
Date
Msg-id 20773.1077905537@sss.pgh.pa.us
Whole thread Raw
In response to Convert INT to INTERVAL?  (Brian Knox <laotse@aol.net>)
List pgsql-sql
Tree view 
Brian Knox <laotse@aol.net> writes:
> 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?

Sure, just multiply by the appropriate interval value:

regression=# select 48 * '1 month'::interval;?column?
----------4 years
(1 row)
        regards, tom lane

pgsql-sql by date:

Previous
From: Michael Chaney
Date:
Subject: Re: Convert INT to INTERVAL?
Next
From: Bruce Momjian
Date:
Subject: Re: User defined types -- Social Security number...