Finding daterange in SQL

Question

Suppose I have two dates

And I want to find birth date that falls between above two dates like birth date between '04-16'(mm-dd) and '05-01'(mm-dd)

Please help me to find this.

What have you tried so far? We're glad to help, but not just do it for you. — dmeglio, Apr 16 '16 at 13:43
Possible duplicate of [SQL query to select dates between two dates](http://stackoverflow.com/questions/5125076/sql-query-to-select-dates-between-two-dates) — Charlie Egan, Apr 16 '16 at 15:06

Peter Szekeli · Answer 1 · 2016-04-16T14:00:18.883

0

Simply use Between

SELECT * FROM yourtable WHERE DateOfBirth BETWEEN '2016-04-16' AND '2016-05-01'

UPDATE
Try this, it'll ignore the year part, using Convert

SELECT
    *
FROM
    yourtable
WHERE
    CONVERT(varchar(5), DateOfBirth, 110) BETWEEN '04-16' AND '05-01'

edited Apr 16 '16 at 14:00

answered Apr 16 '16 at 13:20

Peter Szekeli

it is not fix that year of birth date = 2016. It may be any year but we can find date from month and day. – user3909223 Apr 16 '16 at 13:23
@user3909223 I updated the query, now it ignores the year – Peter Szekeli Apr 16 '16 at 13:41

1 Answers1