and again, I misspelled it.... it is "ModifiedTime". The problem
still is cause by the operant ">" (or any) so I am thinking that the
format is different. Thanks ahead for any response.




--- In qodbc@yahoogroups.com, "Robert" <rob_jurado@...> wrote:
>
> 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
> >
>