SQL: How to produce next date given month and day
17:11 23 Jun 2009

In my table, I have two tinyint fields: Month, and Day.

I need a function that produces a datetime value for the next date (including year) from today's date based on the Month and Day fields.

For example, if today's date is 6/23/2009 and:

  • Month = 9 and Day = 7, the result should be 9/7/2009
  • Month 1, Day 1 it would produce 1/1/2010
sql