the date format can vary depending on the tool you are using, it
should be listed in the SQL/ODBC syntax of your product
documentation.

or as i said last time, export the data and view the date format, and
copy this as an example.

brad

On Thu, Dec 25, 2008 at 3:47 AM, 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
>>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww