on 10-20-2007 8:05 PM
Hi all, i need tod do the next stament in progress database
SELECT * FROM TABLE WHERE (TDate= ( GETDATE() - 1 ) )
Do you have any ideas of how can i make this?
Thanks.
Erick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Erick,
The SQL query is executed on the Database by the JDBC adapter and hence you can use the function in the SQL query directly in the JDBC adapter.
For example in the Sender JDBC adapter I have use the SYSDATE in the select query to select the records of a particular day and it worked fine.
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.