Minus # of months

biznez · #1 (**permalink**) 12-09-11, 14:38

Hi, i have a person that has been approved for 8 months
from 01/01/11 to 08/31/11

what is the query to output 6 months

and i would also like another column to show number of DAYS the person has been approved for

Thanks

Pat Phelan · #2 (**permalink**) 12-09-11, 15:26

Get someone that knows SQL to take a look at your tables, it shouldn't take too long.

-PatP

dm1 · #3 (**permalink**) 12-09-11, 17:45

Number of months:

Code:

SELECT DATEDIFF(mm, '2011-01-01', '2011-08-31');

It returns 7 months, why do you need to get 6?

Number of days:

Code:

SELECT DATEDIFF(dd, '2011-01-01', '2011-08-31');

Returns 242 days

Dmitry
--

http://www.sqlines.com - Free online SQL conversion

Internet Services

Web Development

Digital Marketing

Consumer Tech