The solution I found for the same problem was arithmetic subtraction between
unix_timestamp() values.

Hope this helps.

Bogdan

Alex Kirk wrote:

> I've been looking through the manual at www.mysql.com all of the time/date
> functions, and I can't seem to find the one I want: one that will take two
> times and find  the difference between them. Basically, I'd like to be able
> to use this for a report that gives the number of hours worked on a
> particular project, where I'm entering in start and end times; if there's a
> function like period_diff for time, that'd be perfect.
>
> Thanks in advance for your help.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to