MSSQL Time Diff?

[magician911]

i have a date in student.DOB

and i want to get out the student's age. year-months-days old

i basically want to do

current date - student.DOB

please show me how to do this, and what formate my student.DOB date should be in, it currently is in

6/06/1985


MSSQL 2005

[deric]

Hi Magician! Welcome to bytes.com...

By the way, is this your school assignment?

I can help you better by guiding you to this place where you will learn and understand about it better.

If you have an SQL Query Analyzer, or something like that, try to create your own code by following the instructions on that MSDN. When you encounter a problem on your code, feel free to post it here and we will see if we can help you out. Good luck..