Hi:
Please, I´m looking for a SQL query to get data of last 3 months.
(We are in March, 2 so I need a query to show me data from Dec/01/2009
until Feb/28/2010).

Is there any way to do this with SQL ?

Thanks.

The best would be to use a half-open interval:

SELECT <columns>
FROM Foo
WHERE datecol >= DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP) - 3, 0)
AND datecol < DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0);

--
Plamen Ratchev
http://www.SQLStudio.com