Oh... my mistake on my copy-paste.

Actaully it is like this

"SELECT Top 10* FROM Customer where ModifiedTiem > '2008-12-22'"

but it still gives me the same error.

Any ideas


--- In qodbc@yahoogroups.com, Brad <bradwww@...> wrote:
>
> you need something on the left side of the comparison, like this:
>
> "SELECT Top 10* FROM Customer where customer.date > '2008-12-22'"
>
> to see the date format, run a select * from customer
>
> brad
>
> On Wed, Dec 24, 2008 at 11:53 PM, Robert <rob_jurado@...> wrote:
> > Does anyone know the syntax for date fields on the where clause?
> >
> > I am trying to query this:
> >
> > "SELECT Top 10* FROM Customer where > '2008-12-22'"
> >
> > but it is giving me the following error:
> > ERROR [S0000] [QODBCPOS] Invalid operand for operator: >
> >
> > Thank you.
> >
> >
>
>
>
> --
> Brad Waddell, Managing Director
> FLEXquarters.com Limited
> Skype: bradwww
>