|
|
Posted by Erland Sommarskog on 01/23/08 23:25
Plamen Ratchev (Plamen@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, esquel@sommarskog.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
Navigation:
[Reply to this message]
|