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:316119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
