Here is a table
The dt_send_daytime column indicates the time in the format dd: hh: mm: ss. Where dd is the number of the day of the week. If name_ru = hour, then you need to take only the time in the format mm: ss . And if name_ru = Week, then only the day of the week.
How to separate the day of the week from time?
A string of this type as you have recorded in the database is not recognized as DateTime. It is necessary to take it apart. For this, there is a string.Split () method. Get the array. Zero item will be the day of the week.
string dt_str = row["dt_send_datetime"]; string[] dt_str_tmp = st_str.Split(':'); switch (row["name_ru"]) { case "Час": // Можно сразу так. В итоге получим к примеру 4:0 Console.WriteLine(dt_str_tmp[2]+":"+dt_str_tmp[3]); // Можно конвертировать во время // DateTime dt = DateTime.Parse(string.Format("{0}:{1}:{2}", dt_str_tmp[1], dt_str_tmp[2], dt_str_tmp[3])); // и потом вывести // Console.WriteLine(dt.ToString("mm:ss"); // В итоге получим 04:00 break; case "Неделя": Console.WriteLine(dt_str_tmp[0]); break; } You can replace the whole switch , provided that the choice of only two values - "hour" or "week", with:
Console.WriteLine((name_ru == "Час")?dt_str_tmp[2]+":"+dt_str_tmp[3]:dt_str_tmp[0]);
row["dt_send_datetime"].ToString() not rolling? - MaximKFrom the database, get the full date, cast the DateTime type and use the ToString () method. For example string dt = DateTime.Now.ToString("HH:mm") // выведет текущую дату в формате ЧЧ:ММ
Specifically in your case
string dt; if (row["name_ru"] == "Час") { dt = row["dt_send_daytime"].ToString("mm:ss"); } else if (row["name_ru"] == "Неделя") { dt = row["dt_send_daytime"].ToString("dd"); } 
Source: https://ru.stackoverflow.com/questions/523995/
All Articles