Received: from rns.roundnoon.com (alewis@[204.0.130.147]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA25804 for ; Fri, 3 Dec 1999 09:04:27 -0500 (EST) (envelope-from alewis@roundnoon.com) Received: from localhost (alewis@localhost) by rns.roundnoon.com (8.9.1/8.9.3) with ESMTP id IAA12918; Fri, 3 Dec 1999 08:04:09 -0600 Date: Fri, 3 Dec 1999 08:04:08 -0600 (CST) From: Andy Lewis To: Stoyan Genov cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Another Date question In-Reply-To: <199912030832.KAA19606@lorna.digsys.bg> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I knew I was close, this example should be used in the documentation. I'd certainly be helpful! Thanks. Andy On Fri, 3 Dec 1999, Stoyan Genov wrote: > Hi, > No need of functions. You can do it like this: > > CREATE TABLE mytable (mydate datetime DEFAULT now() + '@60 days'); > > Regards, > Stoyan Genov > > > Hello All! > > > > I'd like to create a table with a datetime field that defaults to +60 > > days. > > > > mydate datetime default 'now() +@60 days', > > ... > > > > Doesn't seem to work. > > > > What am I missing? > > > > Thanks > > > > Andy > > > > > > ************ > > > >