Re: Problems with time calculation

On Thu, 28 Sep 2000, Mai Truong wrote: > I need some help for the following problem: > > I created a table with two columns taking the column type 'time' . > Trying to subtract the times that I filled in from each other, PHP only > delivers the difference of the values of the hours. > Could anyone tell me , what I did wrong or how I should proceed to get the > result in the format hh:mm:ss? > Thanx in advance > Mai Without seeing what your code does it's a bit hard to say what you have done wrong, if anything. The function you probably want to look at is date(), or you might even be able to do the calculation in your sql query, depending on your database package/version. -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA