mysql - version 3.23.40-log (build from src) i have created a database that records ahrs worked and have 2 fields (amongst others) ahrs_start & ahrs_end both are set as type time (hh:mm:ss)
as we get paid for a minmum of 1hr for being called out i would like to be able to craft a query that subtracts ahrs_end from ahrs_start and then does a ceiling() on the difference. so that it displays effectivly everything rounded up to the highest hour has anyone done something similar??? Barry Haycock Sys Admin (UNIX & Networking) ****************************************************************************************************** B-Digital Pty Ltd Level 3, 207 Adelaide Tce Perth, Western Australia 6000 (ph) +61 8 9463 5800 (fax) +61 89463 5955 --------------------------------------------------------------------- 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
