fetching data from SQLite database for specific time slot

Question

I am trying to fetch data from the SQLite database for a specific time period like having a start date and end date. I am unable to find any possible solution for this. Can someone please guide me, on how I'll be able to do this?

Answer 1

You can use between in the query

  SELECT *
  FROM employees
 WHERE StartDate BETWEEN '1/1/2021' AND '1/1/2022';

https://www.techonthenet.com/sqlite/between.php#:~:text=SQLite%3A%20BETWEEN%20Condition%201%20Description.%20The%20SQLite%20BETWEEN,...%206%20Example%20-%20Using%20NOT%20Operator.%20

Answer 2

Hi @Hafeez Niazi

You can do select query from table as suggested by Mr. vb2ae. You need to have datetime column in your table.
Based on format, you do in following ways: (change table name and date column (in where condition) as per your one)

Sample 1. If you don't want to use between then.
select * from tableName where date >= '2022-02-09' and date <= '2022-03-01'

Sample 2: If date column is with timestamp then.

SELECT * FROM tableName WHERE date BETWEEN '2022-02-09 00:00:00' AND '2022-03-01 23:59:59'  

Sample 3: If date column is date only then.

SELECT * FROM tableName WHERE DATE(date) BETWEEN '2022-02-09' AND '2022-03-01'  

Sample 4: if it is text field then.

SELECT * FROM tableName WHERE DATE_FORMAT(date,'%Y-%m-%d') BETWEEN '2022-02-09' AND '2022-03-01'  

Try these query, please let us know if helps you.