Re: Problems querying oracle db from Access 2000

Hi,

little correction inside.
I point it out because Johann wrote that he's new to the Oracle world.

"hrishy" <hrishys_at_yahoo.co.uk> schrieb im Newsbeitrag news:4ef2a838.0308042058.48d13a8c_at_posting.google.com...
> Hi Jhweb
>
> Try this
>
>
> select * from table1
> where
> DATE_RECEIVED
> between to_date('1/jan/2003','dd-mon-yyyy') and

                  between to_date('1/jan/2003','dd/mon/yyyy') and



>         to_date('30/jun/2003','dd-mon-yyyy')



          to_date('30/jun/2003','dd/mon/yyyy')

>
>
> regards
> Hrishy
>
> P.S:If now roes are returned then run the query in sql plus and see
> what is happening..If there is a mismtach the odbc driver is doin
> somethin funny

Greetings,
Guido Received on Tue Aug 05 2003 - 10:19:38 CEST