3 Replies Latest reply on Aug 4, 2008 8:16 AM by Tom Cunningham

    Current system date in where-condition ?

    Raghavan TV Newbie

      I have a simple table where I store my Orders.
      e.g.

      DB - Oracle 10g
      Table

      ORDER_QUEUE
      ----------------------------------------
      ORDER_ID NUMBER(5)
      FIELD1 VARCHAR2(10)
      FIELD2 VARCHAR2(10)
      ORDER_DATE DATE
      ESB_STATUS VARCHAR2(1)
      TIMESTAMP_COL DATE
      -----------------------------------------
      My requirement is to process only those records where ORDER_DATE = Current System Date that hosts my AppServer

      Am trying to work with the sample provided. How do I configure my where condition to pick only those order that matches current system date?


      <sql-bus busid="helloSQLChannel" >
      <sql-message-filter
      tablename="ORDER_QUEUE"
      status-column="ESB_STATUS"
      ------->?? where-condition="ORDER_DATE = ()"
      message-column="message"
      message-id-column="ORDER_ID"
      insert-timestamp-column="TIMESTAMP_COL"
      />
      </sql-bus>


      Thanks,
      -Raghav