From: Peter Abilla <[EMAIL PROTECTED]> > (Column Two - Column One) = Total Minutes
This is quite a hack, and there's probably a better way. But it works: SELECT ROUND( (unix_timestamp(column_one) - unix_timestamp(column_two)) /60 ) as my_minutes; > I've scoured the mysql site and haven't found something that addresses this. > Any ideas? I found this by searching for 'date'. Then, after learing how to use UNIX_TIMESTAMP(), I searched for 'round' (on a hunch) and found that MySQL has a rounding function that fixed my number for me. --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql --------------------------------------------------------------------- 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
