Re: Problems querying oracle db from Access 2000

From: hrishy <hrishys_at_yahoo.co.uk>
Date: 4 Aug 2003 21:58:55 -0700
Message-ID: <4ef2a838.0308042058.48d13a8c_at_posting.google.com>

select * from table1

	where 
		DATE_RECEIVED 
                between to_date('1/jan/2003','dd-mon-yyyy') and
		        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 Received on Tue Aug 05 2003 - 06:58:55 CEST

This message: [ Message body ]
Next message: Rauf Sarwar: "Re: Character Scanner Utility Error!!!!"
Previous message: Keld Nielsen: "Re: sqora.gid and sqora.fts file"
In reply to: jhweb: "Problems querying oracle db from Access 2000"
Next in thread: Shawn: "Re: Problems querying oracle db from Access 2000"
Reply: Guido Konsolke: "Re: Problems querying oracle db from Access 2000"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message