List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 4 2002 10:00pm
Subject:Re: difference between two times
View as plain text  
At 13:54 -0800 3/4/02, Nathan Cowles wrote:
>lastout and firstin contain times such as 13:28:01 and 13:27:54.
>
>If I use the query you gave me from within phpMyAdmin, the result I get is
>7 seconds, exactly what it should be...but I do not know how to use PHP to
>get the correct result, it is giving me 23. I am accustomed to using
>mysql_result to get results but it needs to know the result variable
>($result), the row (should be 0?), and then the last one is usually the
>field name, but in this case I don't think I have one because I'm asking
>it to select a math operation, so where does the result go, and how do I
>get it with PHP?  Thanks.

If you want to give the result a name, just supply a column alias and use
the alias in your mysql_result() call.  But in this case, I don't know if
that's the problem.

Generally, when someone says that they can't tell what's wrong because
not enough of the code is shown, that means you should show some more of
the actual code.  Not give some sort of verbal description of the problem.

>
>Nathan Cowles
>
>On Mon, 4 Mar 2002, Paul DuBois wrote:
>
>>  At 13:35 -0800 3/4/02, Nathan Cowles wrote:
>>  >Paul,
>>  >
>>  >You're awesome...thank you.  One more question pertaining to this...
>>  >
>>  >I'm accustomed to selecting a variable and using something like this:
>>  >
>>  >$firstin = mysql_result($result,$row,firstin);
>>  >
>>  >to set my variable.
>>  >
>>  >What do I want to do here to get the right result into my variable?
>>  >
>>  >$query2 = "SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') -
>>  >TIME_TO_SEC('$firstin'))";
>>  >$result2 = mysql_db_query($database, $query, $connection) or die
>>  >("Error in query: $query. " . mysql_error());
>>  >
>>  >This isn't working, I get 23:
>>  >
>>  >$total = mysql_result($result2,0);
>>
>>  I guess it depends on what the values of $firstin and $lastout are, and
>>  how you're displaying the value of $total.  It's hard to say anything
>>  without seeing more of the code.
>>
>>  >
>>  >Thanks again!
>>  >
>>  >Nathan Cowles
>>  >
>>  >On Mon, 4 Mar 2002, Paul DuBois wrote:
>>  >
>>  >>  >Hello,
>>  >>  >
>>  >>  >I am trying to get an accurate (nearest 15 minutes would be
>>  >>  >fine) difference between two times that I have in my 
>>database.  They are
>>  >>  >both of type time, and are in the format 00:00:00.
>>  >>  >
>>  >>  >For example, if I want the difference between 09:20:00 and
> 10:43:00, I
>>  >>  >would like it to give me 01:23:00 as the answer, but all I 
>>have been able
>>  >>  >to get it to do is give me one.  It is rounding to the nearest
> hour.
>>  >>  >
>>  >>  >I found this query which seems like it would work, but gives me a
> NULL
>>  >>  >result set:
>>  >>  >
>>  >>  >SELECT DATE_SUB('11:48:02', INTERVAL '10:37:37' HOUR_SECOND);
>>  >>
>>  >>  For two times t1 and t2, compute the difference in seconds like this:
>>  >>
>>  >>  SELECT TIME_TO_SEC(t2) - TIME_TO_SEC(t1)
>>  >>
>>  >>  If you want the result as a time value, pass it to SEC_TO_TIME():
>>  >>
>>  >>  SELECT SEC_TO_TIME(TIME_TO_SEC(t2) - TIME_TO_SEC(t1))
>>  >>
>>  >>
>>  >>  >
>>  >>  >I am trying to do all of this from PHP, so if you happen to 
>>know of a way
>>  >>  >to make it do the subtraction in PHP without losing all 
>>accuracy, please
>>  >>  >let me know.
>>  >>  >
>>  >>  >Thanks for any help you can offer.
>>  >>  >
>>  >>  >Nathan Cowles
>>  >>  >StormNet Communications
>>  >>  >530.897.4069
>>  >>
>>  >
>>  >Nathan Cowles
>>  >StormNet Communications
>>  >530.897.4069
>>
>
>Nathan Cowles
>StormNet Communications
>530.897.4069

Thread
difference between two timesNathan Cowles4 Mar
Re: difference between two timesPaul DuBois4 Mar
  • Re: difference between two timesNathan Cowles4 Mar
    • RE: difference between two timesRoger Baklund4 Mar
      • RE: difference between two timesNathan Cowles5 Mar
Re: difference between two timesPaul DuBois4 Mar
  • Re: difference between two timesNathan Cowles4 Mar
Re: difference between two timesPaul DuBois4 Mar
  • Re: difference between two timesNathan Cowles4 Mar
Re: difference between two timesPaul DuBois4 Mar