How do I convert a DateTime table column to a TimeSpan or DayOfWeek ?

[Harry Haller]

The context is shown below in the getGames() method.

I get errors on these lines:

dtGames.Rows[i]["playTime"] = (TimeSpan)dtGam es.Rows[i]["playDate"];
dtGames.Rows[i]["playDay"] = (DayOfWeek)dtGa mes.Rows[i]["playDate"];

because the playDate column is a DateTime.

Here is my solution but I don't like it. What else can I do?

dtGames.Rows[i]["playTime"] =
Convert.ToDateT ime(dtGames.Row s[i]["playDate"]).TimeOfDay;
dtGames.Rows[i]["playDay"] =
Convert.ToDateT ime(dtGames.Row s[i]["playDate"]).DayOfWeek;
public DataView getGames()
{
DataTable dtGames = DAL.GetTable("G ames");
DataColumn colItem;

colItem = new DataColumn("pla yTime",
Type.GetType("S ystem.TimeSpan" ));
dtGames.Columns .Add(colItem);

colItem = new DataColumn("pla yDay",
Type.GetType("S ystem.DayOfWeek "));
dtGames.Columns .Add(colItem);

for (int i = 0; i <= dtGames.Rows.Co unt - 1; i++)
{
dtGames.Rows[i]["playTime"] =
(TimeSpan)dtGam es.Rows[i]["playDate"];
dtGames.Rows[i]["playDay"] =
(DayOfWeek)dtGa mes.Rows[i]["playDate"];
}

dvwGames = dtGames.Default View;
Cache.Insert("G ames", dvwGames);
return dvwGames;
}