Hi! Thanks for all your answers. I'll go for a flexible solution, with one column for day, one for month and if i want to compute the age, a year column. This will also give more flexibility if someone does not want to give his birthdate with precision (He would be able to only give the month, and if he give the year I'll compute his age). Thanks!
2005/8/25, Jigal van Hemert <[EMAIL PROTECTED]>: > Pooly wrote: > > Hi, > > > > I would like to display a list of members who have their birthday a > > given day (today for instance). > > For such an application I've used a single integer column to store a > number consisting of the month and day (day as 2 digits!!!) concatenated. > So dates range from 101 to 1231. The range isn't continuous, but at > least the dates are ordered correctly. > > In this situation you can also easily query ranges (who's celebrating > their birthday in the next week/month/etc.). The only caveat is when the > start and end of the range is in two different years; then you'll have > to split the range up and use a range for each year. > > Regards, Jigal. > -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
