Re: Calculate elapsed time between 2 time/dates

2003-03-13 Thread Paul DuBois
At 12:54 +0100 3/13/03, Roger Baklund wrote: * YC Nyon I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) between 2 time dates. Can't seem to find any of these functions in the Mysql manual. The nearest was Period_diff() which is calculating months elapsed. I don't think you can do it

Re: Calculate elapsed time between 2 time/dates

2003-03-13 Thread Sankaranarayanan Mahadevan
you can use any programmin language to manipulate... i did the following in PHP... //### // Function to calculate remaining days, hours, minu

Re: Calculate elapsed time between 2 time/dates

2003-03-13 Thread Roger Baklund
* YC Nyon > I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) > between 2 time dates. > Can't seem to find any of these functions in the Mysql manual. The nearest > was Period_diff() which is calculating months elapsed. I don't think you can do it directly, you have to split the day and

RE: Calculate elapsed time between 2 time/dates

2003-03-12 Thread YC Nyon
Hi, I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) between 2 time dates. Can't seem to find any of these functions in the Mysql manual. The nearest was Period_diff() which is calculating months elapsed. Thanks Nyon --- Outgoing mail is certified Virus Free. Checked by AVG anti-vi