I would suggest maintaining the date-time column, and creating a set of computed columns which return the values using the DATEPART function. This will allow you to do date arithmetic in the future, as well as view the attributes you need now.