DATE_SUB()

[dude333]

Hi,

I am trying to select all the records in a database table from a given date to 30 days before.

I have this:


"SELECT * FROM records WHERE DATE_SUB('2004-03-15', interval 30 day) AND id=1 ORDER BY date ASC";


For some reason this ignores the date claculation and returns all records in the table for that id.

Can anyone tell me where I am going wrong?

Thanks.

 

[dude333]

Just in case anyone has a similar problem a solution appears to be:


SELECT * FROM records WHERE id=1 AND (date > DATE_SUB('2004-03-15', INTERVAL 29 DAY)
AND date < DATE_SUB('2004-03-15', INTERVAL 0 DAY)) ORDER BY date ASC;

 

[r937]

DATE_SUB('2004-03-15', INTERVAL 0 DAY))

could be simplified to

'2004-03-15'



rudy

http://r937.com/

SQL Consulting