Age calucation

Hai frnds can u tell me the simple syntax using one example how caluclate the aage using system date.i am hanving only DOB field in my table.

Quote:

Originally Posted by chaitanyacrn

Hai frnds can u tell me the simple syntax using one example how caluclate the aage using system date.i am hanving only DOB field in my table.

select datediff(year,DOB,getdate()) from table