Oracle & Sql date help

[emmim44]

my returned date from oracle tb is ‘2008-06-20 00:00:00.0’ and from SQL is ‘6/1/2008 12:00:00 AM’

The EIDs are matched… Which format will make them happy? the cfc returns nothing... any ideas?



<cfquery name="getCSAT" datasource="#arguments.DSN#">

SELECT EID, 0 AS Invalid,

SUM(ORDER_COUNT) AS Value

FROM CCF_Daily_ord_count

WHERE order_date BETWEEN #arguments.StartDate#

AND #arguments.EndDate#

AND EID IN (<cfqueryparam value="#ValueList(arguments.qOper.EID)#" cfsqltype="CF_SQL_VARCHAR" list="Yes">)

GROUP BY EID

</cfquery>

[Dan_Bracuk]

If you have access to the function source code, read it and see what datatype is expected.

[emmim44]

I quite dont understand your upclose reply..

[Dan_Bracuk]

Are you able to read the source code of the cfc you alluded to in your OP?

[emmim44]

Yes. Here is the answer...
WHERE order_date BETWEEN to_date('2008/06/18','YYYY/MM/DD')
AND to_date('2008/06/20','YYYY/MM/DD')