Loading

Check date getting in textbox with date in sql database

Rahul Lakshakar

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Puneet Kankar9y ago
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)
0