House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

Date Range Without Year

Author:
Jim McAtee
12/02/2008 01:52 PM

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


Search cf-talk

March 21, 2010

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
   1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31