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"?
Jump to Post
Not 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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.