How to Calculate Age in Ms-Sql server with SQL Example

3 Comments | 5776 Views | Post by: Admin | Tags: Calcluate age using SQL, SQL query to get age, Sql Tip


Here Pawan Kumar has explained, How to Calculate Age in Ms-Sql Server with SQL Example


Introduction:-

Here Pawan Kumar has explained, How to Calculate Age in Ms-Sql server with SQL Example

Description:-
In previous post I explained In MS-SQL Server How to get tables columns with increment value with SQL Query Example, How can we copy data From one Table to another Table in MS-SQL Server, Get todays Day Name SQL server, how can we convert negative a number to positive number in SQL Server 2005/2008.

In some condtions, We have to calculate the age of the employee so  for that we have to calculate the age into the C#  or also we can calculate age in Ms-Sql server. For this we can create a function in Ms-Sql server and when ever we find the need we can use that function.

Write the following SQL Query into SQL Server Management Studio. In this condition, I'm using the Ms-Sql server 2008 Edition.

This simple SQL will help you to calcuate you age using Ms-Sql server

DECLARE @BirthDate DATETIME
DECLARE @CurrentDate DATETIME

SELECT @CurrentDate = getdate(), @BirthDate = '08/21/1981' --Add your date of birth here

SELECT DATEDIFF(YY, @BirthDate, @CurrentDate) -
CASE
WHEN( (MONTH(@BirthDate)*100 + DAY(@BirthDate)) > (MONTH(@CurrentDate)*100 + DAY(@CurrentDate)) )
THEN 1 ELSE 0 END

Output will be like this

so guys, we have learned in this tutorial, How to Calculate Age in Ms-Sql server with SQL Example

Download Source Codes


Post Comments

if you have some suggestion, question, request on How to Calculate Age in Ms-Sql server with SQL Example.

Please use the comment box to express your views.

 

Comments:

loading...