the query:

SELECT *
FROM `tbl_orders`
where  `order_timestamp` BETWEEN `2007-09-01 00:00:00` AND `2007-10-01 00:00:00` 

the error:

[Live FFF] ERROR 1054: Unknown column '2007-09-01 00:00:00' in 'where clause'