cf query - wanting to set nls date

I have a cf query where i want to set the date format before the query executes.

<CFQUERY NAME="RptQry" datasource="#ds#" username="#user#"
password="#pass#">
alter session set NLS_DATE_FORMAT = 'MM/DD/YYYY'; select * from abc where mydate='7/27/2005';
</CFQUERY>

I am getting an error here, not being able to put these together.

My query is using the date format '7/27/2005', but the sql is expecting it to be '27-Jul-2005'.

I'd like to be able to alter the session before this sql runs.

Is there a better way? Received on Tue Jul 26 2005 - 18:55:29 CDT