time

[dyowel]

Hi, can anyone tell me how I would write a query that will subtract a 2 field using MYSQL.

example :

field 1

10:30:25

field 2

08:15:17

I want to subtract the field1 from field2, can it be done using mysql?

pls help..