From: | <kaiq(at)realtyideas(dot)com> |
---|---|
To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz>, Andy Lewis <alewis(at)roundnoon(dot)com>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-sql <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Re: Datetime operators (was: Re: [SQL] Another Date question) |
Date: | 1999-12-03 19:43:06 |
Message-ID: | Pine.LNX.4.10.9912031336300.13298-100000@picasso.realtyideas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
why
create table mymy (mydate datetime default (now() + '60 days'::timespan ));
does not work?
On Fri, 3 Dec 1999, Thomas Lockhart wrote:
> > > I'd like to create a table with a datetime field that defaults to +60
> > > days.
> > > mydate datetime default 'now() +(at)60 days',
> > > ...
> > Where is a problem?
>
> You have enclosed your default values into a large string, rather than
> letting them be evaluated as an expression:
>
> mydate datetime default (now() + '60 days')
>
> where the outer parens are optional.
>
> > datetime + '10 day' or
> > datetime + '2 year' ..etc.
> > But I'm not sure what is better or exists it in other SQL.
>
> afaik this is the simplest and most direct way to do it. Note that you
> can include other timespan fields in the constant:
>
> mydate datetime default (now() + '60 days 10 hours')
>
> HTH
>
> - Thomas
>
> --
> Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
> South Pasadena, California
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Lewis | 1999-12-03 19:43:32 | Re: Datetime operators (was: Re: [SQL] Another Date question) |
Previous Message | The Hermit Hacker | 1999-12-03 18:37:35 | Re: [HACKERS] postgresql authentification for popper |
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Lewis | 1999-12-03 19:43:32 | Re: Datetime operators (was: Re: [SQL] Another Date question) |
Previous Message | Mario Jorge Nunes Filipe | 1999-12-03 17:28:23 | Re: [SQL] Wierd stuff |