Hello Ivan,
> The original query should select records which date is between now()
> and 7 days in advance. So you can do:
> select * from t1 where datediff(f1, now(), 'day') > 7
Sorry,
select * from t1 where datediff(f1, now(), 'day') between 0 and 7
--
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com
_______________________________________________
Valentina mailing list
Valentina AT lists DOT macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2007 Ivan Smahin |
