469,309 Members | 2,783 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,309 developers. It's quick & easy.

MSSQL Time Diff?

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
1 3578
deric
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.

Similar topics

11 posts views Thread by badz | last post: by
6 posts views Thread by Stefan Behnel | last post: by
2 posts views Thread by Alberto Santini | last post: by
14 posts views Thread by Kukurydz | last post: by
3 posts views Thread by Richard | last post: by
6 posts views Thread by Jeremy Sanders | last post: by
9 posts views Thread by Ron Adam | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.