* YC Nyon > I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) > between 2 time dates. > Can't seem to find any of these functions in the Mysql manual. The nearest > was Period_diff() which is calculating months elapsed.
I don't think you can do it directly, you have to split the day and time part, and calculate the two things separately: The number of days between the two dates AND the difference in the HH:MM:SS-part of the two dates. HTH, -- Roger --------------------------------------------------------------------- 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
