michshelly Posted May 26, 2007 Share Posted May 26, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/53102-how-do-i-put-time-in-a-script/ Share on other sites More sharing options...
btherl Posted May 30, 2007 Share Posted May 30, 2007 '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 Quote Link to comment https://forums.phpfreaks.com/topic/53102-how-do-i-put-time-in-a-script/#findComment-264503 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.