Current system date in where-condition ?

[tvraghavan]

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

[tvraghavan]

Quick update

I updated the where condition as follows and it works

where-condition="TO_CHAR(ORDER_DATE,'DD-MON-YYYY') = (SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') FROM DUAL)"

But the query is more specific to a Oracle DB. Also if the DB and AppServer are in different TZ, we have a problem

Is there some other workaround to use the AppServer Date in the where-condition ?

Thanks,
-Raghav

[tvraghavan]

sorry... The following where condition works.

But I wanted to check if there is a better approach?

where-condition="TO_DATE(ORDER_DATE,'DD-MON-YYYY') = (SELECT TO_DATE(SYSDATE,'DD-MON-YYYY') FROM DUAL)"

[tcunning]

"Is there some other workaround to use the AppServer Date in the where-condition?"

That would definitely require code changes. You could write up a JIRA for enhancement for that if you want.