update time

[Anon]

I am using a form in page 1 to update a table which contains one row in time type.

No when I use the form. I made the input of time type text and filled it out as 01:20:34

when I submit and go to page 2 (which does the updating it updates all the fields except the field time, should I use another type in the form to update a timetype?

any suggestion?

thx

[[deleted]]

Did you read this?

http://www.mysql.com/doc/T/I/TIME.html

[Anon]

Ok thx, this got me a little further but there is still a problem:

When the time stored in the database is lest say 00:02:20 and I update it using the form and only 45 seconds must be added (according to the link you gave me i should notate it as 000045) the end result SHOULD be: 00:03:05 BUT is really is: 00:00:45 to it doesn't update it, it replaces it whenever the seconds (or minutes or hours) reach the level of next minute.
When I would update this example (00:02:20) with say 10 seconds (000010) it does it right and makes it 00:02:30..

How do I get that right?

[[deleted]]

Actually the time should be replaced with whatever you specify. If you say
UPDATE table SET timefield="000045";

the time should be set to 00:00:45.

If there was any value there before, it should be overwritten.

If you want to add time to a timefield, you'll have to use a the date_add() function:

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

like:
UPDATE table SET timefield=date_add(timefield,20 second);

[Anon]

hmmm...thx so far...hope I can figure it out