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["playTime"] = (TimeSpan)dtGames.Rows["playDate"];
dtGames.Rows["playDay"] = (DayOfWeek)dtGames.Rows["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["playTime"] =
Convert.ToDateTime(dtGames.Rows["playDate"]).TimeOfDay;
dtGames.Rows["playDay"] =
Convert.ToDateTime(dtGames.Rows["playDate"]).DayOfWeek;


public DataView getGames()
{
DataTable dtGames = DAL.GetTable("Games");
DataColumn colItem;

colItem = new DataColumn("playTime",
Type.GetType("System.TimeSpan"));
dtGames.Columns.Add(colItem);

colItem = new DataColumn("playDay",
Type.GetType("System.DayOfWeek"));
dtGames.Columns.Add(colItem);

for (int i = 0; i <= dtGames.Rows.Count - 1; i++)
{
dtGames.Rows["playTime"] =
(TimeSpan)dtGames.Rows["playDate"];
dtGames.Rows["playDay"] =
(DayOfWeek)dtGames.Rows["playDate"];
}

dvwGames = dtGames.DefaultView;
Cache.Insert("Games", dvwGames);
return dvwGames;
}