Months Between

[mets19@gmail.com]

Hi, I am trying to determine the amount of months between today and a
date stored in the database. But I cannot seem to figure out get the
difference between the two dates. Thanks in advance.

[Plamen Ratchev]

Re: Months Between

You can use the DATEDIFF function to calculate period of time between dates.
Here is example for months:

CREATE TABLE Foo (mydate DATETIME)

INSERT INTO Foo VALUES ('20010106')
INSERT INTO Foo VALUES ('20020506')
INSERT INTO Foo VALUES ('20070901')
INSERT INTO Foo VALUES ('20071201')
INSERT INTO Foo VALUES ('20080101')

SELECT DATEDIFF(month, mydate, CURRENT_TIMESTA MP)
FROM Foo

HTH,

Plamen Ratchev

http://www.SQLStudio.com

[Erland Sommarskog]

Re: Months Between

Plamen Ratchev (Plamen@SQLStud io.com) writes:

You can use the DATEDIFF function to calculate period of time between
dates.
Here is example for months:
>
CREATE TABLE Foo (mydate DATETIME)
>
INSERT INTO Foo VALUES ('20010106')
INSERT INTO Foo VALUES ('20020506')
INSERT INTO Foo VALUES ('20070901')
INSERT INTO Foo VALUES ('20071201')
INSERT INTO Foo VALUES ('20080101')
>
SELECT DATEDIFF(month, mydate, CURRENT_TIMESTA MP)
FROM Foo

For mets19 we should point out that datediff counts the number of cross
boundaries, so datediff(MONTH, '20080131', '200800201') returns 1, which
may or may not be what you want.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx