How Do You Compare Date Values

I'm stuck trying to compare date values from users selection against a database. I also need to add a condition statement on if the results return no match. How would I do that?





Also, I'm not even sure if my SELECT statement is right. The user will hit a date that will be in format m/d/yyyy and that will be compared to see if it exist in the database. The datebase column "date_created" is default with date/time( 8 ). But when I compare the to together, nothing returns back. The page loads successfully, but no results from the database.





Here is my code:


dim conpubs as sqlconnection


dim cmdSelectAuthors as sqlcommand


dim dtrAuthors As sqlreader





conpubs = New sqlconnection(configurationsettings.appSettings("STD"))


conpubs.open()


cmdSelectAuthors = New sqlcommand("Select * From HotNews WHERE date_created=" & y, conpubs)


dtrAuthors = cmdSelectAuthors.ExecuteReader()


Response.Write("<table><tr><td>")





While dtrAuthors.Read()


Response.Write(dtrAuthors("title") & "<br>")


End While





Response.Write("</td></tr></table>")





dtrAuthors.close()


conPubs.close()