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

Search cf-talk

July 04, 2009

<<   <   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   

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


Mailing Lists