🚀 go-pugleaf

I've tried it in that format and still got 0 records in my
result set. Any other ideas?

"mymn" <yusairi@yahoo.com> wrote:
>for your information,
>if you're using Oracle8i, it's not same as SQL Server format in ADO.
>please check your date format for SQL Select statement.
>try this :-
>
>SELECT CUSTOMER
>FROM TABLE_1
>WHERE SUBMITTED >= '01-Dec-2003' and SUBMITTED <=  '01-Jan-2004'
>
>or
>
>SELECT CUSTOMER
>FROM TABLE_1
>WHERE SUBMITTED >= '2003-12-01' and SUBMITTED <=  '2004-01-01'
>
>
>
>"Brian Plotkin" <brian.plotkin@fnc.fujitsu.com> wrote in message
>news:40327cfc$1@newsgroups.borland.com...
>>
>> Hello all,
>>
>> --> Sorry for the cross post, I meant to post this message
>> here, not in the sqlservers group. <--
>>
>> I have a simple query :
>> SELECT CUSTOMER, SUBMITTED FROM TABLE_1
>> WHERE SUBMITTED BETWEEN '01-Dec-2003' AND '01-Jan-2004'
>>
>> If I submit this query through SQL Explorer, I get what I
>> expect.
>>
>> If I submit this query through an ADOQuery in my application,
>> I get a result set of 0 (zero) records.
>>
>> The database is Oracle 8i and my compiler is BCB 6 (Enterprise),
>> in case you wanted to know.
>>
>> Any ideas??
>>
>
>