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  [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.
Waiting for fix in a future version of Toad for Data Analysts.
Issue found when working with DB2.