> -----Original Message----- > From: tamouse mailing lists [mailto:[email protected]] > Sent: 20 October 2011 21:37 > > On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike <[email protected]> > wrote: > >> -----Original Message----- > >> From: Ron Piggott [mailto:[email protected]] > >> Sent: 17 October 2011 18:38 > >> > >> What I am storing in the table is the start month # (1 to 12) and > >> day # (1 to 31) and then the finishing month # (1 to 12) and the > >> finishing day # (1 to 31) > >> > > > > This is a little bit of a tricky one, as you have to consider both > > start_month and end_month as special cases - so you need a three- > part > > conditional, for the start month, the end month, and the months in > > between. Something like this: > > > > SELECT * FROM `introduction_messages` > > WHERE (month>`start_month` AND month<`end_month`) > > OR (month=`start_month AND day>=`start_day`) > > OR (month=`end_month` AND day<=`end_day`); > > This still suffers from the problem in Jim's offer -- wrap of year > and > wrap of month
Look again. Month wrap *is* handled by the specific tests for start_month and end_month. As to year-wrap, Ron's original post said: > >> ... The reason I didn’t use ‘DATE’ is because the same message > >> will be displayed year after year, depending on the date range. so I didn't bother about year-wrap, assuming he would include a range with start_date of 1/1 and another with end_date of 31/12. Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries and Learning Innovation, Portland PD507, City Campus, Leeds Metropolitan University, Portland Way, LEEDS, LS1 3HE, United Kingdom E: [email protected] T: +44 113 812 4730 But in the case of years actually mattering then, yes, the above would not work To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm
