Check date getting in textbox with date in sql database

Question

Hello,

 

I am trying to match date with date save in sql database. The date in database has the type datetime. So i am not getting how to check it?

 

Please help me 

Answer 1

you match date with convert both value in 103 for or other format.

 

SELECT * from tablename where  convert(date, columnname, 103) =convert(date, @textboxvalue, 103)