How get data between two ranges dates

Question

In SQL I write a SELECT statement to fetch data between two range dates, using between and ..if i use betwenn ('01/01/2013') and ('31/12/2015') i get all data but i want just between the specified dates...exclude year of 2014

Ex:

select * 
from xxx 
 where  date between ('01/01/2013') and ('31/12/2013')
                        and  date between ('01/01/2015') and ('31/12/2015')

But it returned 0 rows.

Use Or instead of And

Siyual
– Siyual

2015-07-23 15:24:06 +00:00
Commented Jul 23, 2015 at 15:24 — Siyual
– Siyual, Commented Jul 23, 2015 at 15:24
thanks man ...it works perfectly

gilas
– gilas

2015-07-25 08:06:32 +00:00
Commented Jul 25, 2015 at 8:06 — gilas
– gilas, Commented Jul 25, 2015 at 8:06

juergen d · Accepted Answer · 2015-07-23 15:24:28Z

3

Use or instead of and

select * 
from your_table
where date between ('01/01/2013') and ('31/12/2013')
   or date between ('01/01/2015') and ('31/12/2015')

You don't want data that is in both date ranges what is not possible at the same time. You want data that is in either one of them.

answered Jul 23, 2015 at 15:24

juergen d

205k40 gold badges303 silver badges376 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

D'Arcy Rittich · Accepted Answer · 2015-07-23 15:29:41Z

1

A succinct way that may not perform as well is:

select * 
from xxx 
where Year(date) in (2013, 2015)

answered Jul 23, 2015 at 15:29

D'Arcy Rittich

172k41 gold badges297 silver badges287 bronze badges

Collectives™ on Stack Overflow

How get data between two ranges dates

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related