[Resolved] time - time = time?

[zingbats]

Hi!

I am working on a thingy where u start a script, go through some pages and end up at another script.

I have made a database with "starttime" and "finishttime".

I need a way to save the times (not the query, a way of getting the time) so that the times can be taken away from each other accounting for things like 00.00 (midnight etc).

So start time = 20.00 (8pm)
Finish time = 22.00 (10pm)

so Finish time - start time = 2 hours.

Any help will be useful

Alex.

[pyro]

When inputting the time into the database, use a timestamp, as this will allow you to format it as you'd like later, and will also allow you to subtract the time difference.

[zingbats]

ok, how do u do the timestamp, and how do you convert it into a time that can be taken away from the other (remember, time deals with 60s not 100s -- to 10.20 - 8.30 = 1.50 NOT 1.90!)

[stolzyboy]

all you do it set the mysql field type to timestamp, then use the [man]date[/man] function to manipulate the timestamp field