Newbie SQL on date data type column

I am experiencing a problem with my simple SQL. I am getting an error message stating that the month is not recognized. What changes do I need to make to my query?

Select *
From servtime
Where starttime between '2003-10-29 09:00:00' and '2003-10-29 12:00:00'

The data type for for the starttime column is DATE. The values in this column appear in this format YYYY-MM-DD HH:MM:SS

Any pointers would be greatly appreciative.

Thanks, Received on Fri Jan 31 2003 - 21:37:15 CST