best way to calculate date

[mourinho]

hi pals
What is the best way to select records of the database that are not older than a week ? I thought that maybe INTERVAL would suit but the problem is that my date format is yyyy-mm-dd.

any ideas!! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[mac]

This should work
here's the code

SELECT
foo
FROM
table
WHERE
datecol >= DATE_SUB( NOW(), INTERVAL 7 DAY )

cheers -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --