Troubleshooting - How to use Between in QODBC

Problem Description:

I need to use Between, in range of dates to return new customer in one period, I try this:

SELECT FullName FROM Customer Where TimeCreated Between {d'2007-12-18'} AND {d'2007-12-19'} AND SalesRepRefFullName='PD'

The use Between with QODBC is correct? 

Solution:

The use of BETWEEN here is fine, it's just TimeCreated is a TIMESTAMP, not a date. It should be:

SELECT FullName FROM Customer Where TimeCreated Between {ts'2007-12-18 00:00:00.000'} AND {ts'2007-12-19 00:00:00.000'} AND SalesRepRefFullName='PD'