# Region obtain the time of the day of the week
Week = datetime. Today. dayofweek. tostring ();
Switch (week)
{
Case "Monday ":
Week = "Monday ";
Mondaytime = datetime. today;
Tuesdaytime = datetime. Today. adddays (1 );
Wednesdaytime = datetime. Today. adddays (2 );
Thursdaytime = datetime. Today. adddays (3 );
Fridaytime = datetime. Today. adddays (4 );
Saturdaytime = datetime. Today. adddays (5 );
Sundaytime = datetime. Today. adddays (6 );
Break;
Case "Tuesday ":
Week = "Tuesday ";
Mondaytime = datetime. Today. adddays (-1 );
Tuesdaytime = datetime. today;
Wednesdaytime = datetime. Today. adddays (1 );
Thursdaytime = datetime. Today. adddays (2 );
Fridaytime = datetime. Today. adddays (3 );
Saturdaytime = datetime. Today. adddays (4 );
Sundaytime = datetime. Today. adddays (5 );
Break;
Case "Wednesday ":
Week = "Wednesday ";
Mondaytime = datetime. Today. adddays (-2 );
Tuesdaytime = datetime. Today. adddays (-1 );
Wednesdaytime = datetime. today;
Thursdaytime = datetime. Today. adddays (1 );
Fridaytime = datetime. Today. adddays (2 );
Saturdaytime = datetime. Today. adddays (3 );
Sundaytime = datetime. Today. adddays (4 );
Break;
Case "Thursday ":
Week = "Thursday ";
Mondaytime = datetime. Today. adddays (-3 );
Tuesdaytime = datetime. Today. adddays (-2 );
Wednesdaytime = datetime. Today. adddays (-1 );
Thursdaytime = datetime. today;
Fridaytime = datetime. Today. adddays (1 );
Saturdaytime = datetime. Today. adddays (2 );
Sundaytime = datetime. Today. adddays (3 );
Break;
Case "Friday ":
Week = "Friday ";
Mondaytime = datetime. Today. adddays (-4 );
Tuesdaytime = datetime. Today. adddays (-3 );
Wednesdaytime = datetime. Today. adddays (-2 );
Thursdaytime = datetime. Today. adddays (-1 );
Fridaytime = datetime. today;
Saturdaytime = datetime. Today. adddays (1 );
Sundaytime = datetime. Today. adddays (2 );
Break;
Case "Saturday ":
Week = "Saturday ";
Mondaytime = datetime. Today. adddays (-5 );
Tuesdaytime = datetime. Today. adddays (-4 );
Wednesdaytime = datetime. Today. adddays (-3 );
Thursdaytime = datetime. Today. adddays (-2 );
Fridaytime = datetime. Today. adddays (-1 );
Saturdaytime = datetime. today;
Sundaytime = datetime. Today. adddays (1 );
Break;
Case "Sunday ":
Week = "Sunday ";
Mondaytime = datetime. Today. adddays (-6 );
Tuesdaytime = datetime. Today. adddays (-5 );
Wednesdaytime = datetime. Today. adddays (-4 );
Thursdaytime = datetime. Today. adddays (-3 );
Fridaytime = datetime. Today. adddays (-2 );
Saturdaytime = datetime. Today. adddays (-1 );
Sundaytime = datetime. today;
Break;
}
There is a time field in the table. This field is used to obtain records within one day.
It mainly uses the datediff function of SQL: returns the number of days between two dates.
Format: datediff (Datepart,Startdate,Enddate)
The SQL statement for returning data within a day is:
select top 7 CartoonName,PlayDate,PlayTV from T_CartoonPlay where DateDiff(d,PlayDate,'" + SundayTime + "')=0
D indicates the day, the number of days, which can also be year, month yy, mm. The whole SQL statement means to retrieve all the data whose time difference from sundaytime and playdate in the table is 0,
Returns all data of the current day.