4 Replies Latest reply on Sep 23, 2008 10:02 AM by emmim44

    Oracle & Sql date help

    emmim44 Level 1
      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>