c# - 在c#中将dd/mm/yyyy字符串转换为yyyy-dd-mm DateTime

Question

如何在 c#中将 13/05/2019 (dd/mm/yyyy) 字符串转换为 2019-13-05 (YYYY-dd-mm) DateTime数据类型，sql 服务器需要 YYYY-dd-mm 格式数据类型

string dateTime = "05/13/2019";

if (animalAdoption.AdoptionId != 0)
{
    AnimalsAndBirdsAdoption animalsAndBirdsAdoption = new AnimalsAndBirdsAdoption()
    {
        AnimalsAndBirdsId = animalAdoption.AnimalId,
        DonarDetailsId = userId,
        Term = model.Term,
        PeriodOfAdoption = dateTime,
        isActive = true,
        Amount = animalAdoption.amount
    };
    if (context.AnimalsAndBirdsAdoptions.Any(e => e.Id == animalAdoption.AdoptionId))
    {
        context.AnimalsAndBirdsAdoptions.Attach(animalsAndBirdsAdoption);
    }
    else
    {
        context.AnimalsAndBirdsAdoptions.Add(animalsAndBirdsAdoption);
    }
}

这个输出我得到

标签： c#asp.netlinq

Answer 1

您可以简单地使用以下示例并使用您所需的格式来做到这一点：

string dateTime = "05/13/2019";

CultureInfo provider = CultureInfo.InvariantCulture;  
// It throws Argument null exception  
DateTime dateTime10 = DateTime.ParseExact(dateTime, "yyyy/dd/mm", provider);