<mreaves@aidt.edu> writes
>Group,
>
>
>
>I have 3 times in a mysql database. Start time, end time and amount of time
>spent at lunch. All are in a time field. How can I figure the daily time,
>end-start-amount time spent at lunch, with php?
SELECT TIMEDIFF(TIMEDIFF(timeend,timestart),lunch) FROM mytable
--
Pete Clark
Advertise your events in Spain - local and free
http://hotcosta.com/events.php
------------------------------------
Are you looking for a PHP job? Join the PHP Professionals directory Now!
http://www.phpclasses.org/professionals/Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-objects/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php-objects/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:php-objects-digest@yahoogroups.com
mailto:php-objects-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
php-objects-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
No comments:
Post a Comment