/SQL/How to get number of months between 2 dates sql server

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

Source: stackoverflow.com

Similar codes

8 votes198 views2 answers
Alert table name mysql
SQL
2 votes231 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote222 views1 answer
Sqlalchemy case insensitive like
SQL
1 vote205 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
-1 vote200 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote202 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
4 votes186 views1 answer
Mysql copy table with new name
SQL
1 vote276 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
1 vote201 views2 answers
Postgresql backup and restore globals and data
SQL
2 votes203 views1 answer
Enum in SQL Server
SQL