Datediff differences in US and Europe

[Ivan Smahin]

On Jun 28, 2012, at 10:51 PM, jda wrote:

> BTW, I'm open to any other suggestion about how to determine, in SQL, if a record was added within a certain time X before the present. That is
> 
> select * from t1 WHERE dateAdded > current time - 14 days
> 
> Jon

select * from t1 where datediff( now(), f1, 'day') > 14

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com