I have a DateTime list that stored in the SQLite database and I try to read the date value that fall in specific date range from the file.
Currently, I am able to read the date value that fall in the specific range.
Original DateTime List:
11-08-2021 15:16:44
11-08-2021 17:09:22
11-09-2021 17:20:39
...
11-11-2021 09:31:54
11-11-2021 10:35:37
11-11-2021 10:45:11
11-11-2021 11:54:28
Datetime List that fall in the specific date range:
11-11-2021 09:31:54
11-11-2021 10:35:37
11-11-2021 10:45:11
11-11-2021 11:54:28
The next thing that I want is I want to check the Datetime difference among the date value that I filtered out before.
For example, there is more than 1 hour difference between 09:31:54 and 10:35:37. How I detect the time difference between these two dates? While between 10:35:37 and 10:45:11, there is not more than 1 hour, so just ignore it. The way I want to check in this way because when the DateTime difference is more than 1 hour between the date, I need to run something in the DateTime behind.
Is it possible to check in this way? I stuck at here and have no idea how can I check the time difference among all the date value. Any suggestion?
What I have tried:
Here is the code that I read the date value that fall in specific date range.
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + path)
{
connection.Open();
string queryDate = DateTime.Now.AddHours(-6).ToString("MM/dd/yyyy HH:mm:00Z");
string consulta = $"SELECT * FROM LastRun WHERE LastUpdatedTime > '{queryDate.ToString()}' ";
using (SQLiteCommand commandReader = new SQLiteCommand(consulta, connection))
{
SQLiteDataReader reader = commandReader.ExecuteReader();
while (reader.Read())
{
DateTime suaData = Convert.ToDateTime(reader[0]);
Console.WriteLine("datetime: " + suaData);
}
}
}