----- Original Message -----
From: "Ann W. Harrison"
To: <ib-support@yahoogroups.com>; <ib-support@yahoogroups.com>
Sent: Friday, March 15, 2002 8:00 PM
Subject: Re: [ib-support] Re: DATE


> At 04:08 PM 3/15/2002 +0000, Artur Anjos wrote:
>
> >And what if Maria really want it to be that way?
> >
> >This works:
> >
> >MyDate DATE DEFAULT CURRENT_DATE;
> >
> >This don't:
> >
> >MyDate DATE DEFAULT (CURRENT_DATE+1);
>
>
> You could also try
>
> mydate date default 'tomorrow';
> mydate date default 'yesterday';
> mydate date default 'today';
>
> Regards,
>
>
> Ann
>