there is a table. both "age" and "DOB" columns are there.
how to give a SQL command to make "AGE" a derived attribute from "DOB"?
thanks
silvercats
10
Junior Poster
Recommended Answers
Jump to PostNot quite sure what you're asking for here. What do you mean by "derived attribute"?
If it is simply to derive an "AGE" column in a select statement, then you can just use the DATEDIFF function and specify the years between the DOB column and GetDate().
If you're looking for …
All 4 Replies
BitBlt
452
Practically a Master Poster
Featured Poster
barb.saunders.5
0
Newbie Poster
BitBlt
452
Practically a Master Poster
Featured Poster
barb.saunders.5
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.