SQL date within a specific range

Question

In SQL Server, and if we have 2 dates, how to return those records having the first date within 6 months before the second date. For example in the following table:

The output will be the highlighted rows in green.

Please note that I'm not trying to calculate the difference between a date from my table and te current date.

Possible duplicate of How do I add months to a CURRENT_TIMESTAMP in SQL? — Andreas
– Andreas, Commented Jan 22, 2018 at 22:54

RoMEoMusTDiE · Accepted Answer · 2018-01-22 22:55:33Z

1

DATEDIFF

select date1,date2
from mytable
where datediff(month,date1,date2) < 7

answered Jan 22, 2018 at 22:55

RoMEoMusTDiE

4,8341 gold badge19 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

SQL date within a specific range

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related