Queries built in Query Builder with where conditions set on date types gives error "SQL0181N  (4232210)

When working in query builder and building a query with a where condition on a set, setting either a date range or a constant will give the following errors when trying to run the query.

Error:9/17/2010 2:53:51 PM 0:00:00.343: DB2 Database Error: ERROR [22007] [IBM][DB2] SQL0181N  The string representation of a datetime value is out of range.  SQLSTATE=22007

Query Builder put in a timestamp value to the end of the date value whose format may not match the set up of the database and data being queried.

WORKAROUND:

None

STATUS:

Waiting for fix in a future version of Toad for Data Analysts.

Issue found when working with DB2.