##### Asked by: Czeslawa Zugschwert

asked in category: General Last Updated: 22nd April, 2020# How do you find age in SQL Server?

**How to Calculate Age in SQL Server**

- A seemingly quick and obvious way to calculate
**age**in years. - This is what DATEDIFF is really doing when you ask it to give you the difference between two dates in years.
- Dividing the
**age**in days by the number of days in a year gives a slightly more accurate result.

Similarly one may ask, how do I calculate age in SQL?

Format todays date and birthdate as YYYYMMDD and subtract today-DOB. Convert that number to float and divide by 10000. The integer of that result is **age**.

Subsequently, question is, how do I calculate years months and days between two dates in SQL? In MS **SQL** Server, the DATEDIFF function is used to get the difference **between two dates** in terms of **years**, **months**, **days**, hours, minutes etc. SELECT DATEDIFF(day, '2018-03-13', GETDATE()) AS "Difference in **days**"

Also to know is, what is the formula to calculate age?

Simply by subtracting the birth date from the current date. This conventional **age formula** can also be used in Excel. The first part of the **formula** (TODAY()-B2) returns the difference between the current date and date of birth is days, and then you divide that number by 365 to get the numbers of years.

What is Floor in SQL?

The **SQL FLOOR**() function rounded up any positive or negative decimal value down to the next least integer value. **SQL** DISTINCT along with the **SQL FLOOR**() function is used to retrieve only unique value after rounded down to the next least integer value depending on the column specified. Syntax: **FLOOR**(expression)