Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3280
Home > Codes >

To find the number of month between two dates of month in SQL Server

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 1107
Post Code | Search Codes | Code Home  
To find the number of month between two dates of month in SQL Server 

 Select SDate, EDate,MONTHS_BETWEEN(EDate,SDate) 
MDuration from tblTime;


Thanks.
Amatya
Alert Moderator 
Bookmark It

Comments or Responses

Login to post response

Latest Code Snipptes