Comparing TimeStamp field

Hi :-),

I hv a TimeStamp field in a table and i want to fetch records tht fall in between the date range.

i m using VB6 for developing front-end app.

Query: SELECT * FROM TableName
WHERE ProductionDateTime BETWEEN '01/Dec/2005' AND '21/Dec/2005'

ProductionDateTime is a TimeStamp field
this is not working. it shows no rows selected.

thnx in advance

Ashu Received on Wed Dec 21 2005 - 23:55:40 CST