Datetime base parameter's fetch data issue on the bases on format

xbjsctsfjnu

New Member
I'm fetching records from the db on the bases of one datetime type field. But the formate i'm saving in the db is like "2013-04-09 15:02:46.803". when i send the parameter of datetime to select record is like '4/9/2013 3:07:26 PM'. Actually i'm try to use both like and equal in condition but both not working. As the format of a date should same.
p6S83.png
taIF9.png
 
Top