3 Replies Latest reply: Jul 31, 2012 1:48 AM by 947757 RSS

    Date Parameter Format Issue

    947757
      Hi,

      Good morning especially to reports developer expert I have this query, this work well in sql developer and in the reports builder when I created the report but when we run it in oracle apps there is no output.. I'm thinking the problem might be in the date format of the parameter but couldn't find the cause, Please help..thank you in advance.
      Example:

      SELECT
      VOID_CHECK_ID,
      VOID_CHECK_NUMBER,
      VOID_DATE
      FROM AP_CHECKS_ALL
      WHERE VOID_DATE between NVL(TO_DATE(:FROMDATE,'yyyy/mm/dd HH24:MI:SS'),SYSDATE - 9999)
      AND NVL(TO_DATE(:TODATE, 'yyyy/mm/dd HH24:MI:SS'),SYSDATE - 9999)

      Edited by: 944754 on Jul 5, 2012 11:05 PM