Received: from danbo.digsys.bg (root@danbo.digsys.bg [192.92.129.10]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA31406 for ; Fri, 3 Dec 1999 03:32:58 -0500 (EST) (envelope-from genov@lorna.digsys.bg) Received: from lorna.digsys.bg (root@lorna.digsys.bg [193.68.6.15]) by danbo.digsys.bg (8.9.0/8.9.0) with ESMTP id KAA10974; Fri, 3 Dec 1999 10:32:42 +0200 (EET) Received: from lorna.digsys.bg (genov@localhost.digsys.bg [127.0.0.1]) by lorna.digsys.bg (8.9.0/8.9.0) with ESMTP id KAA19606; Fri, 3 Dec 1999 10:32:38 +0200 (EET) Message-Id: <199912030832.KAA19606@lorna.digsys.bg> X-Mailer: exmh version 2.0.2 2/24/98 To: Andy Lewis cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Another Date question In-reply-to: Your message of "Thu, 02 Dec 1999 21:56:52 CST." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Fri, 03 Dec 1999 10:32:38 +0200 From: Stoyan Genov Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id DAA31421 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 > > > ************ >