Getting current date/time Mac OS total seconds

[Ivan Smahin]

Hello jda,

Friday, December 21, 2007, 3:52:16 PM, you wrote:

> Hi,

> I'd like to be able to search a db for records added within the last 
> "X days" using SQL. I've stored the date entered as total seconds 
> (RB, Mac OS X). With Valentina SQL I can get the date/time in 
> year/month/day/seconds. Has anyone written a formula that will 
> convert this to Mac OS X total seconds?

I think you need date diff sql-function.

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documentation:vsql:reference:expr:functions:datetime

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