Re: Help with Date in Where Clause

2011-01-31 Thread Bruce Ferrell
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 midn

Re: Help with Date in Where Clause

2011-01-31 Thread Shawn Green (MySQL)
On 1/31/2011 15: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 i

Re: Help with Date in Where Clause

2011-01-31 Thread Phillip Baker
Thank you very much Jørn Blessed Be Phillip "Never ascribe to malice what can be explained by incompetence" -- Hanlon's Razor On Mon, Jan 31, 2011 at 1:18 PM, Jørn Dahl-Stamnes wrote: > Jørn

Re: Help with Date in Where Clause

2011-01-31 Thread Jørn Dahl-Stamnes
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 (wit