List:General Discussion« Previous MessageNext Message »
From:Richard Whitney Date:December 6 2004 9:52pm
Subject:SELECT based on TIMESTAMP (DATETIME)
View as plain text  
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
Thread
• SELECT based on TIMESTAMP (DATETIME)Richard Whitney6 Dec