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