That representation makes sense, but there needs to be a way to use it to construct SELECT queries using >=, <=, or BETWEEN. Using expressions with MySQL functions in the SELECT would be ok, if it can be done.
----- Original Message ----- From: "Barney Boisvert" <[EMAIL PROTECTED]> To: "cf-talk" <[email protected]> Sent: Tuesday, December 02, 2008 11:52 AM Subject: Re: Date Range Without Year > You could just use numbers to represent the dates. Year runs from 101 > to 1231 (thats MDD), and easily create from a date like this: > #month(now()) * 100 + day(now())#. Strings would also work instead of > numbers: "0101" to "1231", and created via #dateFormat(now(), > "mmdd")#. > > cheers, > barneyb > > On Tue, Dec 2, 2008 at 10:34 AM, Jim McAtee <[EMAIL PROTECTED]> > wrote: >> The DBMS that I'm using is MySQL 5.0. >> >> I have a table where I want to store begin and end dates _without_ a >> year. >> For example, 'Dec 4' through 'Jun 15'. How can I best represent this >> in >> the database? >> >> I'll be doing selects of the nature >> >> SELECT * >> FROM mytable >> WHERE #today# BETWEEN begindate AND enddate >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
