Re: Datetime operators (was: Re: [SQL] Another Date question)

I know, thanks to you, but why? It supposes to work. seems things within
default's parenthesis  are different for no reason.

I mean,  insert into mymy values( now() +  '60 days'::timespan );
works fine. usually the more strict one (diligitantly casted one)
always works. 

I feel pain about it :-) because that was what I tried, and then, since it
did not work, I assumed "default" did not accept expressions.



On Fri, 3 Dec 1999, Andy Lewis wrote:

> Remove the ::timespan and it will.
> 
> Andy
> 
> On Fri, 3 Dec 1999 kaiq@realtyideas.com wrote:
> 
> > 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() +@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@alumni.caltech.edu
> > > South Pasadena, California
> > > 
> > > ************
> > > 
> > 
>