Subject Re: [ib-support] Re: DATE
Author Artur Anjos
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);

Nice question....

Artur



----- Original Message -----
From: "rogervellacott" <rvellacott@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, March 15, 2002 3:44 PM
Subject: [ib-support] Re: DATE


> --- In ib-support@y..., "maria_ana_ph" <maria_ana_ph@y...> wrote:
> > hi!
> >
> > i'm just new with FireBird and i'm going to declare a variable
> with
> > DATE as its dataype. I need to set the default values to a day
> after
> > the current system's date. Do you know how would I go about it?
> >
> > thanks in advance!
> >
> > Maan 8)
>
> Don't bother to declare a variable. Just use (CURRENT_DATE+1), with
> or without brackets, wherever you need it.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>