Re: [SQL] Another Date question

Hi,
No need of functions. You can do it like this:

CREATE TABLE mytable (mydate datetime DEFAULT now() + '@60 days');

Regards,
Stoyan Genov

> Hello All!
>
> I'd like to create a table with a datetime field that defaults to +60
> days.
>
> mydate datetime default 'now() +(at)60 days',
> ...
>
> Doesn't seem to work.
>
> What am I missing?
>
> Thanks
>
> Andy
>
>
> ************
>