17 messages in com.mysql.lists.mysqlRe: Calculations with dates?
FromSent OnAttachments
le...@neland.dk03 Jan 2000 18:08 
le...@neland.dk03 Jan 2000 18:12 
Sasha Pachev03 Jan 2000 22:14 
Thomas David Kehoe05 Jan 2000 09:56 
Thomas David Kehoe05 Jan 2000 10:10 
Michael Budash05 Jan 2000 10:33 
Bill Gerrard05 Jan 2000 10:33 
Mark Zieg05 Jan 2000 10:43 
Sven E. van 't Veer05 Jan 2000 10:57 
Jay J05 Jan 2000 11:03 
Paul DuBois05 Jan 2000 15:41 
Thomas David Kehoe05 Jan 2000 17:22 
Sasha Pachev05 Jan 2000 19:23 
Bill Gerrard06 Jan 2000 01:47 
Paul DuBois06 Jan 2000 04:32 
Peter Speck06 Jan 2000 04:41 
Bill Gerrard06 Jan 2000 11:04 
Subject:Re: Calculations with dates?
From:Bill Gerrard (bi@daze.net)
Date:01/05/2000 10:33:50 AM
List:com.mysql.lists.mysql

How do I tell MySQL to retrieve all records last then one week old?

We used something like...

SELECT * FROM table WHERE TO_DAYS(date) >= (TO_DAYS(CURDATE())-7) ORDER BY date;