I have a table
CREATE TABLE `impressions` (
`timestamp` datetime DEFAULT NULL,
`month` varchar(7) DEFAULT NULL,
`day` date DEFAULT NULL,
month and day fields contains formatted values base on timestamp field.
When I execute the following query it return 8 records:
where (timestamp between '2013-07-08 00:00:00' and '2013-07-08 23:59:59') and storefront = 'sf1'
but next query return 112 records:
where storefront = 'sf1' and day = '2013-07-08'
All values in timestamp, month and day fields correct (I checked it in last query).
Why the first query return less records then last query? This is looks like a bug.