devxlogo

Use SQL Server Date Function to Calculate the Number of Days in a Month

Use SQL Server Date Function to Calculate the Number of Days in a Month

The SQL server date function provides an easy way to calculate the number of days in a month.

To calculate the total number of days in each month in SQL server, you can use datediff as shown:

 Select datediff(dd,'Feb 1, 2000','Mar 1, 2000')

This will give a result of 29 days. This method also works correctly for leap years.

devx-admin

Share the Post: