In dateTime not showing correct time

Hi @ priyanka88,

First of all ,I want to tell you something.

1. First check datatype of @Date parameter.Is it DATETIME
2. If use DateTime.Now to insert value,it will store date with current time stamp(2013/07/17 08:24:26) like this.
3. We use DateTime.Today then it will store date with (00:00:00) tme stamp.

So please tell me what the problem.As you said time is not correct.

So could you please tell what date time values is being inserted. and what value you are getting.