michshelly

Hi there, I'm trying to put time into a script. The time is results of olympic events. Here is some examples of my script: create table Results ( EventID char (4) not null, CompetitorNum numeric (3) not null, ElapsedTime TIME not null, Place numeric (4) not null, CONSTRAINT results_competitornum_fk FOREIGN KEY (competitornum) references Competitors (CompetitorNum), constraint Results_EventComp_pk Primary Key (EventID, CompetitorNum) ); insert into Results values ('S001',132, TIME '4:50.05', 1); insert into Results values ('S001', 166, TIME '54:88',2); I can put the top line in values in the script and it runs okay but when I add more I get this message: ERROR: invalid input syntax for type time: "4:50.05" SQL state: 22007 Can someone please help me please? thanks Michshelly