Convert string to a specific DateTime format.

string strDate = "2022.01.11.00.00.55.";
DateTime dt = DateTime.ParseExact(strDate, "yyyy.MM.dd.hh.mm.ss.",null);
System.Console.WriteLine(dt);
]

Select allOpen in new window

dt is a DATETIME not a string anymore

11-Jan.-2022 12:00:55 AM

string strDate = "2022.01.11.00.00.55.";
DateTime dt = DateTime.ParseExact(strDate, "yyyy.MM.dd.hh.mm.ss.",null);
System.Console.WriteLine(dt);
string date_str = dt.ToString("yyyy-MM-dd HH:mm:ss");
Console.WriteLine(date_str);

Select allOpen in new window

11-Jan.-2022 12:00:55 AM
2022-01-11 00:00:55

David Johnson, CD, Thank you for your quick response.
Looking for "DateTime dt" to be "2022-01-11 00:00:55".
Inputting the string "2022.01.11.00.00.55" to be converted to a DateTime variable of "yyyy-mm-dd hh:mm:ss" format, {2022-01-10 00:00:55}.
The SQL schema for the "TSTAMP" is (datetime, null) but using Europe format not US.

Thank you David Johnson,
It seems that without changing the local PC Date Time property I may not see the desire result.
I will make this closed/solution.

Thanks again.