TFS Integration Tools – What is the new CQQueryTimeDelimiter all about? Q&A-38

We introduced another new custom setting for the Rational IBM ClearQuest adapter, which resolves incompatibility of date/time delimiters amongst different databases. … just when I forgot about those adventures they re-emerge.

… run it against an Access backend and the smoke appears within the migration pipeline. If we change the ‘ date/time delimiter to a # character, then we get a similar looking query that runs against Access QC without breaking a sweat:

To configure the behaviour of the date/time delimiter the latest build (31028.00) allows you to define a new key CQQueryTimeDelimiter, which specifies which delimiter to use. Before you change the default delimiter you should consult your database administrative guide and determine what the correct date/time delimiter is for your database.

Extract from an example configuration file, that changes the default delimiter to a # character. See line 11.