Sending precise datetime to SqlDataSource as parameter?

Use overloaded SqlParameter constructor that is using SqlDbType as parameter.

Use overloaded SqlParameter constructor that is using SqlDbType as parameter SqlParameter(String, SqlDbType, Int32) SqlParameter(String, SqlDbType, Int32, String) Then use SqlDbType. DateTime described on MSDN page as "Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds".

I don't think really answers the question – Simon Halsey Sep 21 '11 at 13:23 Bertus has to decide. And according to this forum thread progtown. Com/… there's an accuracy loss: "Values are rounded to increments of .003, or .007 seconds, as shown in the table." – Karel Frajtak Sep 21 '11 at 14:14 I will mark this up again, simply for introducing the .003 and .007 accuracy info into the discussion.

– Bertus van Zyl Sep 22 '11 at 5:43.

msdn.microsoft.com/en-us/library/z72eefa... you should able be to call tostring on the datetime and the result will include all the parts down to the milliseconds.

Formatting the dates is the root of all evil. – Karel Frajtak Sep 21 '11 at 14:17 Well that maybe so, but it needs to be done – Simon Halsey Sep 21 '11 at 15:35 Why mark this down? A better explanation of what's wrong would be appreciated.

– Simon Halsey Sep 21 '11 at 15:36 In the OP I already state that I know how to add parameter. This is not the issue. The issue is precision on datetime parameters, and the baggage that goes with it.

– Bertus van Zyl Sep 21 '11 at 5:41.

You can specify the Type of the parameter either in the code behind file (like Karel suggested, specifying DateTime) or declarative by setting the Type property Type="DateTime.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.