How do i put time in a script

[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

 

 

[btherl]

'00:04:50.05" is valid syntax for time, but not '4:50.05'. 

 

Here is the full list of valid inputs:

 

http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html#DATATYPE-DATETIME-TIME-TABLE