How to insert only day and month or month and year or any combination in a date field sql server
===

I have a date of birth field in the database which is of datatype date. I have three dropdowns for the same in my aspx page. One dropdown for day,one for month and one for year. If the user selects only day and month or month and year or any combination. How to insert that into the date field into the database.

If the user selects 10/09/0000. How to insert this into the database?

Thanks,