Re: [MYSQL]time of elapsed time

Weston, Craig (OFT) wrote: There were 2 changes - First was IF(`status` = 'WIP',SUM(time_to_sec(RIGHT(`CLOCK_TIME`),8)),0) AS 'WIP' ( I addded the "RIGHT" limit on the string) And second was grouping by KEY,STATUS Further experimentation makes it appear that I am getting the right number of

RE: [MYSQL]time of elapsed time

y the sender immediately by reply e-mail and delete the e-mail from your system. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 12:02 PM To: mysql@lists.mysql.com Subject: Re: [MYSQL]time of elapsed time Weston, Craig (OFT) wrote: &

Re: [MYSQL]time of elapsed time

Weston, Craig (OFT) wrote: Baron, thank you for your response. I did get a different result for the query: 18184639,12544976,0,0,0,0,0,0,0,0,0,0,0,0 But it still is "all" the data for the ticket in the row. If I group by the ticket (key) number and the status, I get one line per status with t

RE: [MYSQL]time of elapsed time

ail from your system. -Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, October 19, 2007 8:53 AM To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com Subject: Re: [MYSQL]time of elapsed time Hi Craig, Weston, Craig (OFT) wrote: > Hello everyone. > > Onc

Re: [MYSQL]time of elapsed time

Hi Craig, Weston, Craig (OFT) wrote: Hello everyone. Once again, I am jousting at the windmill of time and date formulae within MYSQL. I seek to create a cross-tab or pivot table of the SUM of all times with a specific category, on a per-ticket basis. I have everything working except the math

[MYSQL]time of elapsed time

Hello everyone. Once again, I am jousting at the windmill of time and date formulae within MYSQL. I seek to create a cross-tab or pivot table of the SUM of all times with a specific category, on a per-ticket basis. I have everything working except the math part. Even that is kind of working ok, b

Re: Calculate elapsed time between 2 time/dates

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

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

* 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

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

Re: Elapsed time

Rich, You can try TO_DAYS() first before finding the diff. of the two dates. Perhaps this would give you a better solution. Hasan - Original Message - From: "Rich Duzenbury" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 5:22 AM

Elapsed time

Ver 8.0, Distrib 3.22.32. I have two fields in a table that are TIMESTAMP fields. I'd like to show the amount of elapsed time between the two timestamps in a human readable format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27 days 9 hours 13 minutes 42