How to get number of months between 2 dates sql server

CREATE FUNCTION FullMonthsSeparation 
(
    @DateA DATETIME,
    @DateB DATETIME
)
RETURNS INT
AS
BEGIN
    DECLARE @Result INT

    DECLARE @DateX DATETIME
    DECLARE @DateY DATETIME

    IF(@DateA < @DateB)
    BEGIN
        SET @DateX = @DateA
        SET @DateY = @DateB
    END
    ELSE
    BEGIN
        SET @DateX = @DateB
        SET @DateY = @DateA
    END

    SET @Result = (
                    SELECT 
                    CASE 
                        WHEN DATEPART(DAY, @DateX) > DATEPART(DAY, @DateY)
                        THEN DATEDIFF(MONTH, @DateX, @DateY) - 1
                        ELSE DATEDIFF(MONTH, @DateX, @DateY)
                    END
                    )

    RETURN @Result
END
GO

SELECT dbo.FullMonthsSeparation('2009-04-16', '2009-05-15') as MonthSep -- =0
SELECT dbo.FullMonthsSeparation('2009-04-16', '2009-05-16') as MonthSep -- =1
SELECT dbo.FullMonthsSeparation('2009-04-16', '2009-06-16') as MonthSep -- =2

Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
get number of months between two dates sql server SQl server select get number of months between two dates SQl select select get number of months between two dates SQl select get number of months between two dates months between in sql query difference of months between two dates sql from different years number of months between two dates in sql how to get months between two dates coulmn in sql how to get months between two dates in sql calculate number of months between two dates in sql sql calculate number of sales for each months between two dates find value within 1 month and 2 months of date sql sql date difference in years months and days count months in a time period between two dates sql server count months in a time period between two dates sql months between two dates sql sql server get months of n years count months between current date and other dates sql count months between dates sql date diff to get month and days in sql server sql select all months between two dates get number of months since the data sql get all the month between the given 2 dates in sql server between months in sql CALCULATE NUMBER OF MONTHS IN SQL HOW TO WORK OUT MONTHS FROM TWO DATES SQL how to get number of months betweeen two dates sql sql server get number of days between two dates how to get dates which are gereater than past two months in sql SQL select months between dates sql get number of years between two dates get month days in between two dates in sql server CALCulate months between 2 dates sql months between in sql no. of months between two dates sql sql query for getting months and years name and number between two dates sql query for getting months name and number between two dates SQL Query to find no. of months between 2 dates sql server month two digits sql get months between two dates get month number in sql server in 2 digit month Months between two dates in SQL Get all months and year between two dates SQL sql select counts of months between two dates sql query to find number of weeks between two dates counting months between two dates in sql how to count months between two dates in sql sql server check for data 3 months since now how can i get the month difference between two dates sql server How to get difference between two dates in Years, Months and days in Sql Server sql function returns number of months between two dates. months between two dates in sql server number of months between two dates sql query months between 2 dates sql sql server get no of months between two dates more than 15 days sql count number of months between two dates date between months sql sql datediff 6 months how to get days between to months in SQL how to get difference between two dates in years months and days in sql server number of months between two dates sql server get no of months between two dates get number of years between two dates sql check months between two dates sql server sql server get records for each months between two dates for loop search between two dates in sql
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source