JDBC Receiver Adapter
I am doing a JDBC to Mail Scenario.
In my JDBC Adapter I need to check the current time in the where caluse.
For eample, in the configuration channel, I need to use an sql statement like the following
select a, b from table
<b>where time > currentTime.
or where date > currentDate</b>
Now, I have troubles to define currentTime or Date in the where caluse.
Can someone please point me to the currect syntax.