T-SQL: Get Age from Date of Birth

I just like tiny SQL tricks. Once I posted how to Get only Date from DateTime without performing any casting or conversion.

So...

Sometimes it is useful for social oriented networks to calculate on the fly or store user age given his/her date of birth. Below is a small snippet in T-SQL:

SELECT FLOOR(DATEDIFF(DAY, @BirthDate, @TargetDate) / 365.25)

Related Posts:

• MSSQL 2005 Tip: Using TOP with Subquery
• T-SQL Query Processing Order
• How to Insert DBCC Output into MSSQL Table
• MSSQL: sp_xml_preparedocument is not supported in fibers mode
• MSSQL: Got arithmetic overflow for INT ?
• MSSQL 2005 Express Edition - unbeatable
• T-SQL: The Rozenshtein Method
• Always Use Stored Procedures in MSSQL
• MSSQL 2005 Service Pack 1 is available
• Enterprise Library: Bug with decimal in DataAccess block