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() +@60 days',
> ...
> 
> Doesn't seem to work.
> 
> What am I missing?
> 
> Thanks
> 
> Andy
> 
> 
> ************
>