我试图从C#中保存当前的日期时间格式,并将其转换为SQL Server日期格式,如so yyyy-MM-dd HH:mm:ss
,以便我可以将其用于UPDATE
查询.
这是我的第一个密码:
DateTime myDateTime = DateTime.Now;
string sqlF或mattedDate = myDateTime.Date.ToString("yyyy-MM-dd HH:mm:ss");
date上的输出是可以的,但时间总是"12:00:00",所以我将代码更改为:
string sqlF或mattedDate = myDateTime.Date.ToString("yyyy-MM-dd") + " " +
myDateTime.TimeOfDay.ToString("HH:mm:ss");
它给了我一个编译错误:
格式化异常未处理
并建议我需要解析.因此,根据我在StackOverflow中的研究,我try 对我的代码执行以下操作:
string sqlF或mattedDate = myDateTime.Date.ToString("yyyy-MM-dd") + " " +
myDateTime.Parse.TimeOfDay.ToString("HH:mm:ss");
或
string sqlF或mattedDate = myDateTime.Date.ToString("yyyy-MM-dd") + " " +
myDateTime.tryParse.TimeOfDay.ToString("HH:mm:ss");
But it's telling me that it's a method which is not valid f或 given context. I tried searching f或 solutions to my problem and I have been stuck f或 two hours now. I'm still a bit new in C#, can you help me please?