mardi 27 octobre 2015

MVC 5 and Sql server date filter issue

I have datetime values in my database table like "05/05/2015 23:00:00", I am putting date filer in my query and try to fetch all the data of "05/05/2015"date as below

select * from table where date<="05/05/2015". It's not giving me record which have value "05/05/2015 23:00:00" in database.

Please suggest the way..

Aucun commentaire:

Enregistrer un commentaire