Export Table Using QUERY Parameter with Dates

Hello,

In Oracle9i on Sun Solaris 8 can someone please post an example of doing an export using the QUERY= parameter using a date range.

The docs I have found have examples of text but no date examples and the syntax for QUERY= seems a bit tricky as you need control characters in some cases etc.

For example how would this be implemented:

SELECT to_date('2002-07-01','YYYY-MM-DD') FROM history BETWEEN to_date('2002-07-01','YYYY-MM-DD') AND to_date('2002-09-30','YYYY-MM-DD');

Thanks very much,

Michael Received on Sat Oct 15 2005 - 09:34:14 CDT