List:General Discussion« Previous MessageNext Message »
From:Jason Pyeron Date:July 27 2005 4:40pm
Subject:Re: Hour counts
View as plain text  
mysql> select *,timediff(end,start) from foo;
+---------------------+---------------------+----+---------------------+
| start               | end                 | id | timediff(end,start) |
+---------------------+---------------------+----+---------------------+
| 2005-07-14 15:00:00 | 2005-07-14 17:30:00 |  1 | 02:30:00            |
| 2005-07-14 23:00:00 | 2005-07-15 01:30:00 |  2 | 02:30:00            |
| 2005-07-14 15:00:00 | 2005-07-15 02:30:00 |  3 | 11:30:00            |
| 2005-07-14 15:00:00 | 2005-07-14 16:00:00 |  4 | 01:00:00            |
+---------------------+---------------------+----+---------------------+

On Wed, 27 Jul 2005, [iso-8859-2] Gyurasits Zolt
> Hello All!
>
>
> I would like to calculate the hour counts from 2 'datetime'.
> Example:   2005-07-27 18:00 and 2005-07-27 19:30  => 1,5 hour
>
> I try this....  but not good!
>
> R1 : munkaido_end-munkaido_start  /simple substract/
> R2 : ROUND(ROUND((end-start)/10000)+
> (((end-start)/1000-(ROUND((end-start)/10000)*10))/6),1)  /good if is in one day/
> R3 : ROUND((end-start)/10000)-76  /-76 because from 14. to 15. I don't understand/
>
>
> start               end                  R1                R2          R3
> 07-14 15:00     07-14 17:30     23000           2.5         -74
> 07-14 23:00     07-15 01:30     783000         78.5         2
> 07-14 15:00     07-15 02:30     873000         87.5         11
> 07-14 15:00     07-14 16:00     10000           1             -75
>
> Please help me...    (exist a function for this situation?)
>
>
> Tnx!
>

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                      PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager             7 West 24th Street #100     -
- +1 (443) 921-0381                 Baltimore, Maryland 21218   -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.
Thread
Hour countsGyurasits Zoltán27 Jul
  • Re: Hour countsMartijn Tonies27 Jul
  • Re: Hour countsJason Pyeron27 Jul
  • Re: Hour countsmfatene27 Jul
    • Re: Hour countsmfatene27 Jul
  • Re: Hour countsGyurasits Zoltán27 Jul
    • Re: Hour countsSGreen27 Jul
      • Re: Hour countsGyurasits Zoltán27 Jul
      • Re: Hour countsEric Bergen27 Jul
        • Re: Hour counts2wsxdr528 Jul
RE: Hour countsTerry Spencer27 Jul