Inserting Birthday in Database?
Posted on 2009-05-13
I am creating a very simple table which will consist of Users Birtday (month and day only)
i created a Table
create 2 col.
Username type varchar
Bday type Datetime
now on ASP side i need to be able to insert the birthday to DB.
so i created 3 dropdownlist
1-User 2-Month 3-Day
all of them are populated .
now here is my problem not sure how i can insert it into DB as a DateTime format ... my goal is i need to be able to insert it and then write a simple SQL to show me all upcoming Birthdays for the next month.