By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,759 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Months Between

P: n/a
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.
Jan 23 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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_TIMESTAMP)
FROM Foo

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Jan 23 '08 #2

P: n/a
Plamen Ratchev (Pl****@SQLStudio.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_TIMESTAMP)
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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jan 23 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.