From: | Andy Lewis <alewis(at)roundnoon(dot)com> |
---|---|
To: | Stoyan Genov <genov(at)digsys(dot)bg> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] Another Date question |
Date: | 1999-12-03 14:04:08 |
Message-ID: | Pine.LNX.4.05.9912030802590.12901-100000@rns.roundnoon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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() +(at)60 days',
> > ...
> >
> > Doesn't seem to work.
> >
> > What am I missing?
> >
> > Thanks
> >
> > Andy
> >
> >
> > ************
> >
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Jorge Nunes Filipe | 1999-12-03 15:24:18 | Wierd stuff |
Previous Message | Dirk Lutzebaeck | 1999-12-03 13:57:25 | Howto to force NULL rows at the bottom ? |