Bedford Bob wrote:
I'd like to retrieve the total amount of time the articles have been in the site from 2005-01-01 to 2005-01-31 and divide them by 365 (or 366 if leap year).if an article has been online from 2004-10-01 to null (meaning the article hasn't been sold yet) then I may count 365 days
Did you mean from 2005-01-01 to 2005-12-31? --J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
