-
1. Re: Current system date in where-condition ?
tvraghavan Aug 3, 2008 2:28 AM (in response to 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 -
2. Re: Current system date in where-condition ?
tvraghavan Aug 4, 2008 2:24 AM (in response to 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)" -
3. Re: Current system date in where-condition ?
tcunning Aug 4, 2008 8:16 AM (in response to tvraghavan)"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.