[megglz]

I have database table with records. The time for each record is stored as 'month year' e.g 'July 2010'. How can I return things from the last 3 months?

I tried something like

select * from data
where time >= DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP) - 3, 0)
AND time <  DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0);

but it only returns last month.

Any ideas?

[megglz]

Oh, it actually works. Nevermind