472,127 Members | 1,960 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

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


MSSQL 2005
Apr 15 '08 #1
1 3639
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.