Hello! I need to pull records from the db where the timestamp column (2004-11-01 00:00:00) greater than November 1, 2004
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) >= a.createdate doesn't work DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= a.createdate doesn't work a.createdate > '2004-11-01 00:00:00' doesn't work a.createdate LIKE '2004-11%' OR a.createdate LIKE '2004-12%' doesn't work MySQL 4.1.5-gamma-standard Thanks for any help R. Whitney Transcend Development "Producing the next phase of your internet presence" http://xend.net Premium Quality Web Hosting http://hosting.xend.net rw AT xend.net Net Binder http://netbinder.net 310-943-6498 602-288-5340 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]