This returns zero records

SELECT * FROM Customer WHERE TimeModified > {ts '2005-07-01 00:00:00.000'}

This returns the correct records (Over 200 records in my case)

SELECT * FROM Customer WHERE TimeModified > {ts '2005-07-01 00:00:00.001'}

Note the only difference is the time is set to .001 seconds after midnight.

This appears to be a bug in QODBC v6.00.00.176. The workaround is to specify the columns to be used in the query (instead of Select *) ie:

SELECT "Name","LastName","FirstName","BillAddressAddr1",
"BillAddressAddr2","BillAddressCity",
"BillAddressState","BillAddressPostalcode",
'TimeModified' from Customer WHERE TimeModified > {ts '2005-07-01 00:00:00.000'}

and

SELECT "Name","LastName","FirstName","BillAddressAddr1",
"BillAddressAddr2","BillAddressCity",
"BillAddressState","BillAddressPostalcode",
'TimeModified' from Customer WHERE TimeModified > {ts '2005-07-01 00:00:00.001'}

IMPORTANT: Further testing showed that these issues only happen with the QuickBooks Online Edition and SDK 3.0 versions of QuickBooks (non-USA editions of QuickBooks). The above SQL statements work correctly with USA editions of QuickBooks 2006.