Question
Oracle & Sql date help
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>
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>
AdChoices