the most common date format is this one:

DateFrom = {d'2007-01-01'}, DateTo= {d'2008-01-01'}

i found this by doing a search of our web support system from
qodbc.com - it was the first post listed.

brad


On Thu, Dec 25, 2008 at 3:52 AM, Robert <rob_jurado@...> wrote:
> 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
>> >
>>
>
>



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