How do I compare DATETIME() values in a SQL view?

If I create a view like this:

CREATE SQL VIEW "V_Order2" ;
REMOTE CONNECT "WAREHOUSE" SHARED AS ;
SELECT *;
FROM orders Orders;
ORDER BY Orders.timestamp ;
where Orders.timestamp > datetime() - 86000

I get an error for Incorrect syntax. What I want to do is see all
records for today's date.

I've played around with the SQL date functions, but can't seem to figure
out a combination that allows me to compare these values. Seems that
the view doesn't like VFP nor SQL functions on the right of the >.

Any help appreciated...

+++ Rick ---