Re: Date manipulation
Jeff Larsen wrote:
>On a table with a DATE column I can do
>
> select datecol from tab where datecol = today + 1;>
>But I get a syntax error on
>
> insert into tab (datecol) values (today + 1);>
>Why the inconsistency? Is there a workaround?
>
>Jeff Larsen
>larsen@qec.com
insert into tab(datecol)select today+1
from systables
where tabid=1
It works.
Bye,
Octav
--
Octav Chiriac Phone: (373) 2 21 20 96
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 24 00 83
Moldova, Republic of mailto:com@netinfo-moldova.com