title: Best way to save only day and month in database
body: <p>We have to save the day and the month of a yearly reoccurring event. (Think of it as the day of they year when the invoice has to be sent to the client.)</p>
  
  <p>We will have to do some computation with this information. E.g if the customer is paying twice per year. Then we do not only have to check if this day is today but also if this day is in 6 month.</p>
  
  <p>We have now several options:
  a) We save the information in a DATE field but ignore the year.
  b) We create two int fields in the database date_day and date_month.
  c) We create a varchar field and then do a regex and split e.g. 31.12 up every time we do some calculation.</p>
  
  <p>We did several tests and found out that c) is definitely too slow. But we still have the option a) and b). First we wanted to go for b) but after some tests we tend more to a).</p>
  
  <p>Is there a good technical reason that would really make one option  a lot better than the other?</p>
  
  <p>(We are using MySQL at the moment. If this is of importance.)</p>