RE: Date Field Help

2001-07-23 Thread Don Read
On 23-Jul-2001 Mike Mike wrote: > Hi Folks, > I'm trying to create a counter for my website. I'm > trying to pull the last 7 days worth of data out of > mysql. My sql statement is as follows. > > SELECT TheDate, Count(TheDate) AS CountOfdate > FROM Counter > WHERE (((TheDate)=Now()-7)) > GROUP

Re: Date Field Help

2001-07-23 Thread David Ecker
Of course, 0 records are ok. Here is an example of mine : mysql> select now(), now()-7; +-++ | now() | now()-7| +-++ | 2001-07-23 21:45:53 | 20010723214546 | +-++ 1 r