Age in Years, months & days in SQL Server 2005.

[codehunter]

I have a field of Date of Birth. Please provide me command/syntax to extract correct Age in Years, months and days all at once for each record as on 30/09/2009 in SQL Server 2005.

[WingedPanther]

Are you wanting them extracted as separate computed fields? If so, check here: DATEPART