Hello Gary Thank you for your timely response, however MySQL server version 3.21.33b responded: ERROR 1064: parse error near '(now(), interval 5 day) and date_sub(now(), interval 2 day) order by datestamp d' at line 2 :-(( when I entered exactly what you suggested. What am I doing wrong? S. >From: "Gary Huntress" <[EMAIL PROTECTED]> >To: "Stefen Lars" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: Selecting 3 days worth of data with an offset of 5 days from >now() >Date: Sat, 31 Mar 2001 09:04:48 -0500 > >Try this: > >select * from visitor where > datestamp between > date_sub(now(), interval 5 day) and > date_sub(now(), interval 2 day) > order by datestamp desc; > >Regards, > >Gary "SuperID" Huntress > >======================================================= >FreeSQL.org offering free database hosting to developers >Visit http://superid.dyndns.org:8080/freesql/index.php > >----- Original Message ----- >From: "Stefen Lars" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, March 31, 2001 1:31 PM >Subject: Selecting 3 days worth of data with an offset of 5 days from now() > > > > Hello all > > > > I am looking for a way to return 3 days worth of data with an offset of >five > > days (in the past) from today. > > > > For example, say we had the following dates and today is 2001-03-31. >First > > we do: > > > > select name, datestamp from visitor_data order by datestamp desc; > > > > and are returned with this list > > > > name datestamp > > > > jon 2001-03-31 > > peter 2001-03-29 > > sam 2001-03-26 > > joe 2001-03-25 > > pete 2001-03-25 > > zed 2001-03-25 > > chris 2001-03-24 > > paul 2001-03-22 > > simon 2001-03-22 > > > > Now, I am looking for a way to return just the following data: > > > > sam 2001-03-26 > > joe 2001-03-25 > > pete 2001-03-25 > > zed 2001-03-25 > > chris 2001-03-24 > > > > How can this be done? > > > > I would be really very grateful if someone could point me in the right > > direction or offer a link to a resource with some example of what I >would > > like to do. I already looked in the manual and the example: > > > > SELECT something FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(date_field) ><= > > 30; > > > > is interesting, but is not really what I want to do. > > > > If anyone can help me, I thank you whole-heartedly in advance. > > > > S. > > > > > > > > >_________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at >http://www.hotmail.com. > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
