Date format in ASP and in SQL 2000 Database
I have alway known that there is an issue when it comes to dates format. Here is what my ASP page does. It contains a text box where users will input their birthday date in mm/dd/yy format. The datatype of the date field in SQL is "datetime." The data looks fine after I have submitted the date into the database(ie. 02/16/88).
Now my question is, if I were to create another ASP page where I enter a birthday to search for, let say birthday >= to 02/16/88, how would I code that? Can I simply do something like:
Select from databasename where birthday_field >= "birthday_search_input"
THanks in advance for your help.