>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() ?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only