Datediff differences in US and Europe

[Ruslan Zasukhin]

On 6/29/12 3:50 PM, "jda" <jda at his.com> wrote:

Hi Jon,

1) Ivan says that he have check this query, and it works for him

2) We think you need send him offlist your db ZIP

3) now()  in Valentina is EXACTLY the current date and time.
  this is not related to any 1904 as you asking ...

 
> On Jun 29, 2012, at 4:34 AM, Ivan Smahin 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
> 
> Sorry, but it's not working. I tried this
> 
> datediff( now(), 'dateadded', 'day') > 14
> 
> (and variants thereof) with no success.
> 
> What is "now" for Valentina on a Mac. Is it the seconds after 1/1/1904 (which
> is how Macs deal with dates)? This is why we had the problem in the first
> place, because we had to subtract the date 1/1/1904 from now() to do the
> comparison.
> 
> Would you please try this yourself? It shouldn't be this difficult.
> 
> We can pursue this off-list.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]