Will
SELECT now() - 'nummonths months'::interval ;
work?
----- Original Message -----
From: "Vince Vielhaber" <vev@michvhf.com>
To: <pgsql-hackers@postgresql.org>
Sent: Wednesday, September 26, 2001 4:30 PM
Subject: [HACKERS] casting for dates
>
> I'm trying to use an integer from a table to add/subtract time in months.
> IOW:
>
> create table foo(nummonths int);
>
> select now() - nummonths months;
>
> So far nothing I've tried will work - short of a function. Is there a
> way to do this?
>
> Vince.
> --
> ==========================================================================
> Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
> 56K Nationwide Dialup from $16.00/mo at Pop4 Networking
> Online Campground Directory http://www.camping-usa.com
> Online Giftshop Superstore http://www.cloudninegifts.com
> ==========================================================================
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>