blocks|key|186611|text|在下面尝试一下|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186612|DateTime+myDateTime+=+DateTime.Now;
string+sqlFormattedDate+=+myDateTime.ToString("yyyy-MM-dd+HH:mm:ss.fff");|code-block|syntax|javascript|186613|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

try this below 

<pre><code>DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff");
</code></pre>

blocks|key|186625|text|您的第一个代码将通过执行以下操作来工作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186626|DateTime+myDateTime+=+DateTime.Now;
string+sqlFormattedDate+=+myDateTime.ToString("yyyy-MM-dd+HH:mm:ss");+//Remove+myDateTime.Date+part+|code-block|syntax|javascript|186627|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Your first code will work by doing this

<pre><code>DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss"); //Remove myDateTime.Date part 
</code></pre>

blocks|key|3011754|text|您的问题出在"+date“属性中，该属性将DateTime截断为date。您可以将转换放在如下位置：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3011755|DateTime+myDateTime+=+DateTime.Now;
string+sqlFormattedDate+=+myDateTime.ToString("yyyy-MM-dd+HH:mm:ss");+//+<-+No+Date.ToString()!|code-block|syntax|javascript|3011756|entityMap^0|L|8|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Your problem is in the "Date" property that truncates <code>DateTime</code> to date only.
You could put the conversion like this:

<pre><code>DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss"); // &lt;- No Date.ToString()!
</code></pre>

blocks|key|186645|text|正确的答案已经给出了“使用参数”。格式化日期并将其作为字符串传递给SQL-Server可能会导致错误，因为这取决于服务器端如何解释日期的设置。在欧洲，我们写“1.12.2012”来表示2012年12月1日，而在其他国家，这可能会被视为1月12日。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186646|在SSMS中直接发出语句时，我使用的格式是yyyymmdd，它似乎非常通用。到目前为止，我在各种安装上都没有遇到任何问题。|offset|length|style|CODE|186647|还有另一种很少使用的格式，它有点奇怪，但适用于所有版本：|186648|select+{+d+'2013-10-01'+}|code-block|syntax|javascript|186649|将于2013年10月1日返回。|186650|select+{+ts+'2013-10-01+13:45:01'+}|186651|将于10月1日下午1:45:01返回|186652|我强烈建议使用参数，并且永远不要通过将自己开发的格式化语句片段粘贴在一起来格式化您自己的SQL代码。它是SQL注入和奇怪错误的入口(格式化浮点值是另一个潜在问题)|186653|entityMap^0|0|L|8|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|13|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

The correct answer was already given "use parameters". Formatting a date and passing it as a string to SQL-Server can lead to errors as it depends on the settings how the date is interpreted on the server side. In europe, we write '1.12.2012' to indicate december 1st 2012, whereas in other countries this might be treated as january 12th.

When issuing statements directly in SSMS I use the format <code>yyyymmdd</code> which seem to be quite general. I did not encounter any problems on the various installations I worked on so far.

There is another seldom used format, which is a bit weird but works for all versions:

<pre><code>select { d '2013-10-01' }
</code></pre>

will return the first of october 2013. 

<pre><code>select { ts '2013-10-01 13:45:01' }
</code></pre>

will return october 1st, 1:45:01 PM

I strongly advice to use parameters and never format your own SQL code by pasting together homegrown formatted statement fragments. It is an entry for SQL injection and strange errors (formatting a float value is another potential issue)

blocks|key|2799555|text|我想要的答案是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2799556|DateTime+myDateTime+=+DateTime.Now;
string+sqlFormattedDate+=+myDateTime.ToString("yyyy-MM-dd+HH:mm:ss");|code-block|syntax|javascript|2799557|我还了解到你可以这样做：|2799558|DateTime+myDateTime+=+DateTime.Now;
string+sqlFormattedDate+=+myDateTime.ToString(myCountryDateFormat);|2799559|其中myCountryDateFormat可以根据需要进行更改以满足更改。|2799560|请注意，标记为“这个问题可能已经有答案了：”实际上并没有回答问题，因为正如您所看到的，它使用了".Date“而不是省略它。对于.NET的新程序员来说，这相当令人困惑|2799561|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

The Answer i was looking for was:

<pre><code>DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss");
</code></pre>

I've also learned that you can do it this way:

<pre><code>DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString(myCountryDateFormat);
</code></pre>

where myCountryDateFormat can be changed to meet change depending on requirement.

Please note that the tagged "This question may already have an answer here:" has not actually answered the question because as you can see it used a ".Date" instead of omitting it. It's quite confusing for new programmers of .NET

blocks|key|3011843|text|为什么不完全跳过这个字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3011844|SqlDateTime+myDateTime+=+DateTime.Now;|code-block|syntax|javascript|3011845|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Why not skip the string altogether :

<pre><code>SqlDateTime myDateTime = DateTime.Now;
</code></pre>

blocks|key|184654|text|使用标准的日期时间格式"s“还将确保国际化兼容性(MM/dd与dd/MM)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|184655|myDateTime.ToString("s");

=>+2013-12-31T00:00:00|code-block|syntax|javascript|184656|完整选项：(代码:示例结果)|184657|d:+6/15/2008+
D:+Sunday,+June+15,+2008+
f:+Sunday,+June+15,+2008+9:15+PM+
F:+Sunday,+June+15,+2008+9:15:07+PM+
g:+6/15/2008+9:15+PM+
G:+6/15/2008+9:15:07+PM+
m:+June+15+
o:+2008-06-15T21:15:07.0000000+
R:+Sun,+15+Jun+2008+21:15:07+GMT+
s:+2008-06-15T21:15:07+
t:+9:15+PM+
T:+9:15:07+PM+
u:+2008-06-15+21:15:07Z+
U:+Monday,+June+16,+2008+4:15:07+AM+
y:+June,+2008+

'h:mm:ss.ff+t':+9:15:07.00+P+
'd+MMM+yyyy':+15+Jun+2008+
'HH:mm:ss.f':+21:15:07.0+
'dd+MMM+HH:mm:ss':+15+Jun+21:15:07+
'\Mon\t\h\:+M':+Month:+6+
'HH:mm:ss.ffffzzz':+21:15:07.0000-07:00|184658|.NET框架支持:+4.6、4.5、4、3.5、3.0、2.0、1.1、1.0|184659|参考：DateTime.ToString+Method|offset|length|style|CODE|184660|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/zdtaw1bw(v=vs.110).aspx^0|0|0|0|0|0|3|H|3|O|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|15|8|@$O|16|P|17|Q|R]]|9|@$O|18|P|19|1|1A]]|A|$]]|$1|S|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

Using the standard datetime format "s" will also ensure internationalization compatibility (MM/dd versus dd/MM):

<pre><code>myDateTime.ToString("s");

=&gt; 2013-12-31T00:00:00
</code></pre>

Complete Options: (code: sample result)

<pre><code>d: 6/15/2008 
D: Sunday, June 15, 2008 
f: Sunday, June 15, 2008 9:15 PM 
F: Sunday, June 15, 2008 9:15:07 PM 
g: 6/15/2008 9:15 PM 
G: 6/15/2008 9:15:07 PM 
m: June 15 
o: 2008-06-15T21:15:07.0000000 
R: Sun, 15 Jun 2008 21:15:07 GMT 
s: 2008-06-15T21:15:07 
t: 9:15 PM 
T: 9:15:07 PM 
u: 2008-06-15 21:15:07Z 
U: Monday, June 16, 2008 4:15:07 AM 
y: June, 2008 

'h:mm:ss.ff t': 9:15:07.00 P 
'd MMM yyyy': 15 Jun 2008 
'HH:mm:ss.f': 21:15:07.0 
'dd MMM HH:mm:ss': 15 Jun 21:15:07 
'\Mon\t\h\: M': Month: 6 
'HH:mm:ss.ffffzzz': 21:15:07.0000-07:00
</code></pre>

Supported in .NET Framework: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0 
Reference: <a href="http://msdn.microsoft.com/en-us/library/zdtaw1bw(v=vs.110).aspx"><code>DateTime.ToString</code> Method</a>

blocks|key|2799623|text|只有你把"T"%2BDateTime.Now.ToLongTimeString()%2B+'2015-02-23‘|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2799624|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

only you put "T"+DateTime.Now.ToLongTimeString()+ '2015-02-23'

blocks|key|186693|text|如果您想用DateTime更新表，可以像下面这样使用SQL字符串：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186694|int+fieldId;
DateTime+myDateTime+=+DateTime.Now
string+sql+=+string.Format(@"UPDATE+TableName+SET+DateFieldName='{0}'+WHERE+FieldID={1}",+myDateTime.ToString("yyyy-MM-dd+HH:mm:ss"),+fieldId.ToString());|code-block|syntax|javascript|186695|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you wanna update a table with that DateTime, you can use your SQL string like this example:
<pre><code>int fieldId;
DateTime myDateTime = DateTime.Now
string sql = string.Format(@&quot;UPDATE TableName SET DateFieldName='{0}' WHERE FieldID={1}&quot;, myDateTime.ToString(&quot;yyyy-MM-dd HH:mm:ss&quot;), fieldId.ToString());
</code></pre>

blocks|key|182401|text|您的问题出在Date属性中，该属性仅将DateTime截断到最新。您可以将转换放在如下位置：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|182402|DateTime+myDateTime+=+DateTime.Now;

string+sqlFormattedDate+=+myDateTime.ToString("yyyy-MM-dd+HH:mm:ss");|code-block|syntax|javascript|182403|entityMap^0|6|4|J|8|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

Your problem is in the <code>Date</code> property that truncates <code>DateTime</code> to date only. You could put the conversion like this:

<pre><code>DateTime myDateTime = DateTime.Now;

string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss");
</code></pre>

blocks|key|183893|text|如果您希望将当前日期存储在表中，以便可以使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|183894|183895|+GETDATE()；|blockquote|183896|183897|183898|或者将此函数作为参数传递|offset|length|style|BOLD|183899|例如：'update+tblname+set+curdate=GETDATE()+where+colname=123'|183900|entityMap^0|0|0|0|0|0|8|2|0|3|1K|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|T|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@$J|X|K|Y|L|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|Z|8|@$J|10|K|11|L|M]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|Q|$]]

if you want to store current date in table so you can use 

<blockquote>
 GETDATE();
</blockquote>

or pass this function as a parameter 

eg. 'update tblname set curdate=GETDATE() where colname=123'

blocks|key|3012074|text|将DateTime从C#传递到SQL+Server的另一种解决方案，而不考虑SQL+Server语言设置|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3012075|假设您的区域设置显示日期为dd.MM.yyyy+(德国标准'104')，那么|3012076|DateTime+myDateTime+=+DateTime.Now;
string+sqlServerDate+=+"CONVERT(date,'"%2BmyDateTime%2B"',104)";+|code-block|syntax|javascript|3012077|将C#+datetime变量传递给SQL+Server+Date类型变量，并根据"104“规则考虑映射。Sql+Server日期获取yyyy-MM-dd|3012078|如果您的区域设置以不同的方式显示DateTime，则使用SQL+Server转换表中的相应匹配|3012079|查看有关规则的更多信息：https://www.techonthenet.com/sql_server/functions/convert.php|offset|length|3012080|entityMap|0|LINK|mutability|MUTABLE|url|https://www.techonthenet.com/sql_server/functions/convert.php^0|0|0|0|0|0|C|1P|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

Another solution to pass DateTime from C# to SQL Server, irrespective of SQL Server language settings
supposedly that your Regional Settings show date as dd.MM.yyyy (German standard '104') then
<pre><code>DateTime myDateTime = DateTime.Now;
string sqlServerDate = &quot;CONVERT(date,'&quot;+myDateTime+&quot;',104)&quot;; 
</code></pre>
passes the C# datetime variable to SQL Server Date type variable, considering the mapping as per &quot;104&quot; rules . Sql Server date gets yyyy-MM-dd
If your Regional Settings display DateTime differently, then use the appropriate matching from the SQL Server CONVERT Table
see more about Rules: <a href="https://www.techonthenet.com/sql_server/functions/convert.php" rel="nofollow noreferrer">https://www.techonthenet.com/sql_server/functions/convert.php</a>

blocks|key|186762|text|我认为问题在于缺少了两个单引号。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|186763|这是我对MSSMS运行的sql：|186764|WHERE+checktime+>=+'2019-01-24+15:01:36.000'+AND+checktime+<=+'2019-01-25+16:01:36.000'|code-block|syntax|javascript|186765|正如你所看到的，有两个单引号，所以你的代码必须是：|186766|string+sqlFormattedDate+=+"'"+%2B+myDateTime.Date.ToString("yyyy-MM-dd")+%2B+"+"+%2B+myDateTime.TimeOfDay.ToString("HH:mm:ss")+%2B+"'";|186767|在MSSQL中甚至在MySQL中，对每个字符串都使用单引号。我希望这能帮到你。|186768|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I think the problem was the two single quotes missing.

This is the sql I run to the MSSMS:

<pre><code>WHERE checktime &gt;= '2019-01-24 15:01:36.000' AND checktime &lt;= '2019-01-25 16:01:36.000'
</code></pre>

As you can see there are two single quotes, so your codes must be:

<pre><code>string sqlFormattedDate = "'" + myDateTime.Date.ToString("yyyy-MM-dd") + " " + myDateTime.TimeOfDay.ToString("HH:mm:ss") + "'";
</code></pre>

Use single quotes for every string in MSSQL or even in MySQL. I hope this helps.

blocks|key|3012151|text|+++DateTime+date1+=+new+DateTime();

++++date1+=+Convert.ToDateTime(TextBox1.Text);
++++Label1.Text+=+(date1.ToLongTimeString());+//11:00+AM
++++Label2.Text+=+date1.ToLongDateString();+//Friday,+November+1,+2019;
++++Label3.Text+=+date1.ToString();
++++Label4.Text+=+date1.ToShortDateString();
++++Label5.Text+=+date1.ToShortTimeString();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3012152|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> DateTime date1 = new DateTime();

 date1 = Convert.ToDateTime(TextBox1.Text);
 Label1.Text = (date1.ToLongTimeString()); //11:00 AM
 Label2.Text = date1.ToLongDateString(); //Friday, November 1, 2019;
 Label3.Text = date1.ToString();
 Label4.Text = date1.ToShortDateString();
 Label5.Text = date1.ToShortTimeString();
</code></pre>

blocks|key|2799893|text|让我们使用内置的SqlDateTime类|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2799894|new+SqlDateTime(DateTime.Now).ToSqlString()|code-block|syntax|javascript|2799895|但是仍然需要检查空值。这将引发溢出异常|2799896|new+SqlDateTime(DateTime.MinValue).ToSqlString()|2799897|SqlDateTime+overflow.+Must+be+between+1/1/1753+12:00:00+AM+and+12/31/9999+11:59:59+PM.|offset|length|style|CODE|2799898|entityMap^0|0|0|0|0|0|2E|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

Let's use the built in SqlDateTime class
<pre><code>new SqlDateTime(DateTime.Now).ToSqlString()
</code></pre>
But still need to check for null values. This will throw overflow exception
<pre><code>new SqlDateTime(DateTime.MinValue).ToSqlString()
</code></pre>
<code>SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.</code>

I am trying to save the current date time format from C# and convert it to an SQL Server date format like so <code>yyyy-MM-dd HH:mm:ss</code> so I can use it for my <code>UPDATE</code> query.

This was my first code:

<pre><code>DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd HH:mm:ss");
</code></pre>

The output on date is okay, but time is always "12:00:00" so I changed my code to the following:

<pre><code>string sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd") + " " + 
myDateTime.TimeOfDay.ToString("HH:mm:ss");
</code></pre>

It gave me this compile error:

<blockquote>
 FormatException was unhandled
</blockquote>

And suggested I need to parse. So I tried doing this to my code as per my research here in StackOverflow:

<pre><code>string sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd") + " " + 
myDateTime.Parse.TimeOfDay.ToString("HH:mm:ss");
</code></pre>

or

<pre><code>string sqlFormattedDate = myDateTime.Date.ToString("yyyy-MM-dd") + " " + 
myDateTime.tryParse.TimeOfDay.ToString("HH:mm:ss");
</code></pre>

But it's telling me that it's a method which is not valid for given context. I tried searching for solutions to my problem and I have been stuck for two hours now. I'm still a bit new in C#, can you help me please?

DateTime format to SQL format using C#

SQL Server

服务器

MySQL

我正在尝试保存来自C#的当前日期时间格式，并将其转换为类似于yyyy-MM-dd HH:mm:ss的SQL Server日期格式，以便我可以将其用于我的UPDATE查询。这是我的第一个代码：DateTime myDateTime = DateTime.Now;string sqlFormattedDate = myDa...

问使用C#将DateTime格式转换为SQL格式
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用C#将DateTime格式转换为SQL格式EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用C#将DateTime格式转换为SQL格式
EN