无法解析该格式的字符串“ 1/29/2020 12:00:00 AM”；转换为有效的DateTime [英] unable to parse a string of this format "1/29/2020 12:00:00 AM" into a valid DateTime

问题描述

我正在使用SVC服务，当我在本地运行它时，我得到的Date字段如下 30/01/2020 00:00:00 并解析此字符串为 DateTime ，如下所示（DateTime.ParseExact（i [ ProjectLastUpdate]。ToString（）， dd / MM / yyyy hh ：mm：ss，CultureInfo.InvariantCulture）.ToString（ yyyy'-'MM'-'dd'T'00'：'00'：'00'Z'）），因为我的本地计算机使用英国的区域设置。但是，当我在Azure Web App中托管服务时，我开始收到如下日期字符串： 1/29/2020 12:00:00 AM ，该服务将在上面的代码上引发此异常字符串未被识别为有效的DateTime 。那么任何人都可以对此提出建议吗？我可以在本地计算机和Azure上标准化日期格式吗？我还可以强制我的代码在两种环境下都能工作吗？

I am working on a SVC service, and when I run it locally I get the Date field as follow 30/01/2020 00:00:00 and I parse this string to be a DateTime as follow (DateTime.ParseExact(i["ProjectLastUpdate"].ToString(), "dd/MM/yyyy hh:mm:ss", CultureInfo.InvariantCulture).ToString("yyyy'-'MM'-'dd'T'00':'00':'00'Z'")), since my local machine uses the United Kingdom regional setting. But when I host the service inside an Azure Web App, I start receiving the date string as follows: 1/29/2020 12:00:00 AM, and the service will raise this exception "String was not recognized as a valid DateTime" on the above code. So can anyone advice on this please? Can I standardize the date format on both local machine and azure? Also can I force my code to work on both environments?

这是我在服务内的完整代码：-

Here is my full code, inside the service:-

using (ClientContext context = TokenHelper.CreateRemoteEventReceiverClientContext(properties))
{
    CamlQuery camlQuery = new CamlQuery();
    camlQuery.ViewXml = string.Format("<View Scope=\"RecursiveAll\"><Query><Where><Eq><FieldRef Name='ID' /><Value Type='Number'>{0}</Value></Eq></Where></Query></View>", listItemID);
    ListItemCollection collListItem = context.Web.Lists.GetByTitle("Project Update System").GetItems(camlQuery);
    context.Load(collListItem);
    foreach (ListItem i in collListItem)
    {
        var mydate = (DateTime.ParseExact(i["ProjectLastUpdate"].ToString(), "dd/MM/yyyy hh:mm:ss", CultureInfo.InvariantCulture).ToString("yyyy'-'MM'-'dd'T'00':'00':'00'Z'"));

推荐答案

i的值[ ProjectLastUpdate] 已经 是 DateTime ，因此无需将其转换为字符串然后进行解析背部。因此，您可以使用简单的类型转换：

The value of i["ProjectLastUpdate"] already is a DateTime, so there's no need to convert it to a string and then parse it back. So you can use a simple typecast:

var mydate = (DateTime) i["ProjectLastUpdate"].

这篇关于无法解析该格式的字符串“ 1/29/2020 12:00:00 AM”；转换为有效的DateTime的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！