curdate make me mad

[nagasea]

pretend today date is 2005-08-18

I tried to select today and yesterday (2 days) in the table using CURDATE() - 2
but it seems doesnt working.
can someone help me here.

SELECT * FROM mytable WHERE DATE_FORMAT(PostedDate, \"%Y-%m-%e\") <= ( CURDATE() - 2)

mytable
2005-08-17 03:44:18
2005-08-18 03:44:18
2005-08-14 03:44:18
2005-08-14 03:44:18
2005-08-12 03:44:18

[Drakla]

You have to use INTERVAL

mysql> SELECT something FROM tbl_name
-> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

[nagasea]

let me try first.
thanks Drakla