Is This Content Helpful?
We're glad to know this article was helpful.
Trying to find jobs by date or filter by date in a query against an Oracle JTX repository causes the following error message:
"The executed query is not executing correctly against the database. Verify the query syntax for your underlying database system."
The query generated by JTX is not a valid Oracle query.
To format the date being searched, use the JTX SQL query functionality and the Oracle to_date or to_char function.