calling data from last 3 months

Posted 06 September 2010 - 07:45 AM

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?

Is This A Good Question/Topic? 0