From: "David Blakey" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, June 29, 2005 12:53 AM Subject: Re: [wdvltalk] selecting dates irrespective of year
> > > > SELECT somedate > > FROM foo > > WHERE DAY(somedate)=2 AND MONTH(somedate)=03; > > > > I prefer to use BETWEEN for this. I think it may be more efficient, > but I have > no proff. > > Regards, > David David, I am wanting to select say, March 12, from a list which may have up to 120 years included (only one year to an entry, of course) as a DATE or DATETIME. So far the only thing that looks to meet that need is using DATE_Format to convert to days of the year and select the appropriate day by number. Maybe I can set year-day via the form script? Joseph ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
