Date Three Days Ago

[Anon]

Hi, I am reading in Dates from a table, I want to be able to say only print out records that are less than three days old. How do I go about this?

Thanks

[philsown]

In mysql you can say:

mysql> SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 3;