From: | Ryan Mahoney <ryan(at)paymentalliance(dot)net> |
---|---|
To: | Vince Vielhaber <vev(at)michvhf(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: casting for dates |
Date: | 2001-09-26 21:14:19 |
Message-ID: | 5.0.2.1.0.20010926171030.05fb8c30@paymentalliance.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Haven't tried yet, but perhaps casting nummonths to an interval datatype
would do the trick.
-r
At 04:30 PM 9/26/01 -0400, Vince Vielhaber wrote:
>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(at)michvhf(dot)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(at)postgresql(dot)org
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com)
>Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 166 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | D. Hageman | 2001-09-26 21:14:22 | Re: Spinlock performance improvement proposal |
Previous Message | Andrew McMillan | 2001-09-26 20:57:19 | Re: casting for dates |