Select data from date range between two dates

Question

I have a table Named Product Sales and it holds data like this  Product ID   Sold by   Qty   From date    To date ----------- --------- ----- ------------ ----------- 3            12        7     2013-01-05   2013-01-07 6            22        14    2013-01-06   2013-01-10 8            11        9     2013-02-05   2013-02-11   Now what is the query if I want to select sales data between two dates from a date range   For example  I want to select sales data from 2013-01-03 to 2013-01-09

User · Answer

This working on SQL Server 2008 R2  Select    from Product sales where From date  between  2013-01-03  and  2013-01-09

User · Answer

You can also try using following fragments   select    from  Product sales  where  From date   gt    2013-01-03  and game date   lt    2013-01-09

User · Answer

This query will help you   select    from XXXX where datepart YYYY create date  gt  2013  and DATEPART YYYY create date  lt  2014

User · Answer

Check this query  i created this query to check  whether the check in date over lap with any reservation dates   SELECT   FROM tbl ReservedRooms WHERE NOT    checkindate  NOT BETWEEN fromdate AND todate   AND   checkoutdate   NOT BETWEEN fromdate AND todate    this will retrun the details which are overlaping   to get the not overlaping details then remove the  NOT  from the query

User · Answer

SELECT   FROM Product sales  WHERE From date between  2013-01-03  AND  2013-01-09

User · Answer

This is easy  use this query to find select data from date range between two dates  select   from tabblename WHERE  datecolumn BETWEEN  2018-04-01  AND  2018-04-5

User · Answer

this is easy  use this query to find what you want   select   from Product Sales where From date lt   2018-04-11  and To date gt   2018-04-11

User · Answer

Here is a query to find all product sales that were running during the month of August   Find Product sales there were active during the month of August Include anything that started before the end of August Exclude anything that ended before August 1st   Also adds a case statement to validate the query  SELECT start date          end date          CASE           WHEN start date  lt    2015-08-31  THEN  true            ELSE  false          END AS started before end of month          CASE           WHEN NOT end date  lt    2015-08-01  THEN  true            ELSE  false          END AS did not end before begining of month  FROM   product sales  WHERE  start date  lt    2015-08-31          AND end date  gt    2015-08-01   ORDER  BY start date

User · Answer

DECLARE  monthfrom int null   yearfrom int null   monthto int null   yearto int null   firstdate DATE null   lastdate DATE null  SELECT  firstdate DATEADD month  monthfrom-1 DATEADD year  yearfrom-1900 0     Setting First Date using From Month  amp  Year   SELECT  lastdate  DATEADD day -1 DATEADD month  monthto DATEADD year  yearto-1900 0     Setting Last Date using From Month  amp  Year    SELECT    FROM tbl Record WHERE   DATEADD yy  Year - 1900  DATEADD m  Month - 1  1 - 1   BETWEEN CONVERT DATETIME   firstdate  102  AND  CONVERT DATETIME   lastdate  102

User · Answer

SELECT NULL       FROM   HRMTable hm NOLOCK        WHERE  hm EmployeeID   123         AND                                             CAST  Fromdate AS date  BETWEEN CAST hm FromDate AS date                            AND CAST hm ToDate AS date                                        OR                         CAST  Todate AS date  BETWEEN CAST hm FromDate AS date                            AND CAST hm ToDate AS date

User · Answer

SELECT   FROM Product sales WHERE   From date  gt    2013-08-19  AND To date  lt    2013-08-23    OR   To date  gt    2013-08-19  AND From date  lt    2013-08-23

User · Answer

select    from table  where    table EndDate  gt   2013-01-05   and  table StartDate  lt   2013-01-07

User · Answer

Just my 2 cents  I find using the  dd-MMM-yyyy  format safest as the db server will know what you want regardless of the regional settings on the server  Otherwise you could potentially run into issues on a server that has its date regional settings as yyyy-dd-mm  for whatsoever reason   Thus   SELECT   FROM Product sales  WHERE From date  gt    03-Jan-2013  AND To date  lt    09-Jan-2013    It s always worked well for me  -

User · Answer

This covers all conditions that you are looking for   SELECT   from Product sales where  From date  lt    2013-01-09  AND To date  gt    2013-01-01

User · Answer

SELECT   from Product sales where  From date BETWEEN  2013-01-03 AND  2013-01-09   OR   To date BETWEEN  2013-01-03  AND  2013-01-09   OR   From date  lt    2013-01-03  AND To date  gt    2013-01-09     You have to cover all possibilities  From Date or To Date could be between your date range or the record dates could cover the whole range   If one of From date or To date is between the dates  or From date is less than start date and To date is greater than the end date  then this row should be returned

User · Answer

Please try   DECLARE  FrmDt DATETIME   ToDt DATETIME SELECT  FrmDt  2013-01-03    ToDt  2013-01-09   SELECT    FROM Product sales  WHERE   FrmDt BETWEEN From date AND To date  OR        ToDt BETWEEN From date AND To date

User · Answer

As you can see  there are two ways to get things done    enlist all acceptable options exclude all wrong options   Obviously  second way is much more simple  only two cases against four    Your SQL will look like    SELECT   FROM Product sales  WHERE NOT  From date  gt   RangeTill OR To date  lt   RangeFrom

User · Answer

Try following query to get dates between the range   SELECT    FROM    Product sales  WHERE   From date  gt    2013-01-03  AND         To date    lt    2013-01-09

User · Answer

You should compare dates in sql just like you compare number values   SELECT   FROM Product sales WHERE From date  gt    2013-01-01  AND To date  lt    2013-01-20

[sql] Select data from date range between two dates

Examples related to sql

Examples related to date

Examples related to range