List:General Discussion« Previous MessageNext Message »
From:mfatene Date:July 27 2005 4:34pm
Subject:Re: Hour counts
View as plain text  
Hi,
You can use Timediff :

mysql> SELECT TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30');
+--------------------------------------------------+
| TIMEDIFF('2005-07-27 18:00', '2005-07-27 19:30') |
+--------------------------------------------------+
| -01:30:00                                        |
+--------------------------------------------------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql>
mysql>
mysql> SELECT TIMEDIFF('2005-07-27 19:30', '2005-07-27 18:00');
+--------------------------------------------------+
| TIMEDIFF('2005-07-27 19:30', '2005-07-27 18:00') |
+--------------------------------------------------+
| 01:30:00                                         |
+--------------------------------------------------+
1 row in set (0.00 sec)

more in http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

Mathias

Selon Gyurasits Zoltán <gyz@stripped>:

> 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!
>


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