Subject Re: [ib-support] Re: DATE
Author Ann W. Harrison
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