Getting current date/time Mac OS total seconds

[jda]

>>
>
>> if MacOSTotalSeconds - oneWeekInSeconds <=
>> storedTotalSecondsWhenCreated then
>>     //this record was created within the last week
>> end if
>
> -- How much seconds passed since 01.01.1900
> SELECT datediff( '1900-01-01 00:00:00', now(), 'second' )
>
Hi Ivan,

It seems that datediff may be broken.

When I do this in VStudio

select datediff( '1900-01-01 00:00:00', now(), 'second' )

I get 887399113

In fact, *any* datediff I do gives me a 9 digit number.


In contrast, REALbasic returns a 10 digit number for totalseconds. And  
the number for a record entered in the last few weeks is

3280653952

Do you see why this happens?

Thanks,

Jon

P.S. Merry Christmas and Happy New Year to you, Ruslan, the Paradigma  
team, and all Valentina developers.