hi i hope someone can help..
i got the following db table
create table project (
projectnr int not null unique,
description varchar(100)not null,
start date not null,
end date not null,
belongs int not null,
lnkontakt varchar(50) not null,
fnkontakt varchar(50) not null,
mkontakt varchar(50) not null,
status int not null,
primary key (projectnr)
);
then i like to add values...
now how can i set the end time? i tried now()+100 but doesnt work.
insert into project values (1,Projektbeschrieb, now(), now()+xx , Zugehörigkeit (Projekt), Konatk Nachname, Kontakt Vorname, Kontakt Mail, Projektstatus);
many thx[/code]