Posted by Erland Sommarskog on 08/27/05 01:36

thrilled (decramer@cox.net) writes:
> with datediff all I can get it to return is months or a total of the
> days...
>
> so if the difference in dates is 12 months 4 days how do I adjust the
> SQL to accommodate both?

As DA Morgan pointed out, the question needs further clarification.
For instance, how many months + days are there from 2005-08-27 to
2005-04-03? From 2004-02-27 to 2005-09-03?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Searching multiple entities at a time
• Prev in forum: Re: Convert float to char
• Thread view: Re: Datediff needs to deliver month AND days

[Reply to this message]