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

dj-nia

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