How can I write sql query to fetch data between start date and end date including records of start date and end date

Asked Jun 12 '17 at 15:30

Active Jun 12 '17 at 15:42

Viewed 240 times

How can I write sql query to fetch data between start date and end date including records which are created on start date value and end date value as well. This is my sql query

Select * from User where CreatedDate Between '06/06/2017' and '06/09/2017'.

But above query result data excluding date '06/06/2017'.

edited Jun 12 '17 at 15:42

Zohar Peled

79,642
10
69
121

asked Jun 12 '17 at 15:30

sbm6070

1

Possible duplicate of [SQL query to select dates between two dates](https://stackoverflow.com/questions/5125076/sql-query-to-select-dates-between-two-dates) – blackandorangecat Jun 12 '17 at 15:32
1

The standard SQL `between` **does** include the start and end date. Can you please show your real query and some sample data? – Jun 12 '17 at 15:34
1

What is your DB? What is your DateFormat? What datatype is `CreteDate` Date or String? Do you include time? – Juan Carlos Oropeza Jun 12 '17 at 15:36
Use `Column >= Start_Date AND Column <= EndDate` instead. – Zohar Peled Jun 12 '17 at 15:43
It works for me – sbm6070 Jun 12 '17 at 17:16

How can I write sql query to fetch data between start date and end date including records of start date and end date

0 Answers0