By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

MSSQL Time Diff?

P: 1
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
Apr 15 '08 #1
Share this Question
Share on Google+
1 Reply


P: 92
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..
Apr 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.