On 01/31/2011 12:18 PM, Jørn Dahl-Stamnes wrote:
> On Monday 31 January 2011 21:12, Phillip Baker wrote:
>
>> Greetings All,
>>
>> I am looking for a little help in setting a where clause.
>> I have a dateAdded field that is a DATETIME field.
>> I am looking to pull records from Midnight to midnight the previous day.
>> I thought just passing the date (without time) would get it but I keep
>> getting an empty record set.
>> So looking for something that works a bit better.
>>
> select * from your_table where convert(dateAdded, date)='2011-01-31';
>
>
not so good, but it works:
select * from your_table where dateAdded like '2011-01-31%';
OR
select * from your_table where dateAdded between '2011-01-30%' and
'2011-01-31%';
better:
select * from your_table where DATE_SUB('2011-01-31', INTERVAL 1 DAY);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
