我从数据库中提取的数据是(string,datetime),我需要检查datetime以查看它是否等于今天的sysdate @ 14:00,但是我不知道如何只查看list中的datetime字段。
int recordCount;
using (IDatabase db = SystemStatus.GetDatabase(_connectionStrings.stuff))
{
const string query= @"
SELECT DISTINCT string, date
FROM table
WHERE date > DATE_SUB(SYSDATE(), Interval 30 day) AND
drop_date < DATE_SUB(NOW(), Interval 12 hour) AND
status_id = 2;";
var records = db.Fetch<Dictionary<string, List<DateTime>>>(query);
recordCount = records.Count;
}
发布于 2018-06-20 06:40:22
您需要一个datetime对象来进行比较:
DateTime now = DateTime.Now;
DateTime dt = new DateTime(now.Year, now.Month, now.Day, 14, 0, 0); // 2 PM today
您不需要"if“语句。您需要使用对象查询(LINQ)...
using System.Linq;
// get everything past 2 PM today
var after2PMRecords = records.Where(r => r.Value > dt);
// get everything before 2 PM today
var before2PMRecords = records.Where(r => r.Value < dt);
https://stackoverflow.com/questions/50937766
复制相似问题