Subject | Re: DATE |
---|---|
Author | maria_ana_ph |
Post date | 2002-03-17T23:58:27Z |
Thanks Ann! really appreciate your help..
--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> 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