Stefan Frederiksen
Reputation: 135
Select records with two dates with 3 months or less between
How can I make a select Query in SQL where I only want records that has 3 or less months between each other?
Date1 and Date2 column in datetime format: 26-06-2014 00:00:00
Upvotes: 0
Views: 939
Answers (1)
Barry
Reputation: 3733
Use DATEDIFF like
WHERE
DATEDIFF(m,Date2,Date1) <= 3
m is specifying that the difference must be calculated in months.
Upvotes: 2
Related Questions
- SQL select where month/year are within 2 dates
- Return all records within 3 month period (MySQL)
- Select records from a table which date will be 3 months from now
- mysql select records greater than 3 months
- SQL Selecting only records matching year and month between two dates
- SQL - select data that have dates greater than a month in a year
- sql query accept only dates of two months
- select records between two months with year difference
- select dates that are between current date and 3 month from the current date in mysql
- Select a DATE that lies any 3 months ago