Getting current date/time Mac OS total seconds

[Ivan Smahin]

Hello jda,

Tuesday, December 25, 2007, 7:56:48 PM, you wrote:

>>>
>>
>>> 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

Seems to be overflow.
Put it to mantis please.


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