I use MYSQL TO_DAYS function to grab some statistics from database and I use next statement:
SELECT ID FROM database WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) >=7 ORDER BY ID DESC I have IIS server and I use Dreamweaver MX to build the statistics page, where we use ASP. Problem is, that I get row from every month with date difference of 7 instead of rows from last seven days. What went wrong? Do I have to specify the date format someway to the TO_DAYS function? Sincerely, Putte Koivisto --------------------------------------------------------------------- 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