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


What about ttod(datetime()) = date() ?