Eiolon Posted September 16, 2008 Share Posted September 16, 2008 I want to the most recent entries in a table but I want to have a cutoff date of 2 weeks. Entries that are more than 2 weeks old won't be listed. All entries are stored with a mysql datetime column: record_added datetime not null default '0000-00-00 00:00:00' Any idea on how I could do this? Thanks! Quote Link to comment Share on other sites More sharing options...
DarkWater Posted September 16, 2008 Share Posted September 16, 2008 #SQL SELECT * FROM your_table WHERE record_added > (DATE_SUB(NOW(), INTERVAL 14 DAYS)) LIMIT 20; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.