<div>
use SqlCommand and SqlParameter.<br />
in c# part, ensure you can parse the user input into a c# date, from there it's dead easy:<br />

<pre><code id="code-370428">    SqlCommand cmd = new SqlCommand(&quot;SELECT * FROM table_name WHERE dateTimeField &gt; @SomeDate&quot;);
    cmd.Parameters.AddWithValue(&quot;@SomeDate&quot;, DateTime.Today);
</code></pre>
</div>


use SqlCommand and SqlParameter.
in c# part, ensure you can parse the user input into a c# date, from there it's dead easy:


    SqlCommand cmd = new SqlCommand("SELECT * FROM table_name WHERE dateTimeField > @SomeDate");
    cmd.Parameters.AddWithValue("@SomeDate", DateTime.Today);


<div>
<br />
I am using such as:<br />
<br />
String.Format(&quot;INSERT INTO MyTable (RecDate) VALUES ({0}) WHERE RecID = {1}&quot;, '19/08/2009', 21)<br />
<br />
The error is coming from SQL 2000 itself.<br />
<br />
<br />

</div>



I am using such as:

String.Format("INSERT INTO MyTable (RecDate) VALUES ({0}) WHERE RecID = {1}", '19/08/2009', 21)

The error is coming from SQL 2000 itself.




<div>
<br />
Thanks. It works well.<br />
<br />
May you guide me to a link that explain this matter.<br />
<br />

</div>



Thanks. It works well.

May you guide me to a link that explain this matter.



<div>
I would start with this link, for the cast/convert function:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a>
</div>


I would start with this link, for the cast/convert function:
http://msdn.microsoft.com/en-us/library/ms187928.aspx [http://msdn.microsoft.com/en-us/library/ms187928.aspx]

<div>
Dear Angel<br />
<br />
What I need to know is how String.Format change the date.<br />
<br />
Thanks<br />
<br />

</div>


Dear Angel

What I need to know is how String.Format change the date.

Thanks



<div>
<div class="content wysiwyg-content">
<br />
I've an application developed in C# connecting to MS SQL 2000. And, some user have dd/mm/yyyy hh:mm AM format, others have mm/dd/yyyy. I got error when I try to insert an new record or work with date.<br />
<br />
What is the shortest way to solve this issue?<br />

</div>
</div>



I've an application developed in C# connecting to MS SQL 2000. And, some user have dd/mm/yyyy hh:mm AM format, others have mm/dd/yyyy. I got error when I try to insert an new record or work with date.

What is the shortest way to solve this issue?


DateTime in MS SQL 2000 With C#

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.