how to create a derived attribute?

[silvercats]

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

[BitBlt]

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 a "derived table", that's really nothing more than joining to a parenthesized "Select" statement. Frankly, in most cases you're better off using straight joins.

If you're talking about a Derived Column transformation in SSIS, then there's a Derived Column Transformation Editor in BIDS that will expose all the properties you need.

If none of these answer your question, please clarify what you're asking for, and perhaps describe more about your scenario.

[barb.saunders.5]

Hi im a beginner in mysql land and i need exactly this i need to derive AGE from my D.O.B column i am wondering if you could explain whether i need to do this...

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().

and whether you could break it down more simply...

i know im asking alot but we all have to learn ..

hopefully

barb :D

[BitBlt]

Hi, @barb.saunders.5 and welcome to DaniWeb.

Please note that this thread is for MS SQL, and you'd probably get a better answer if you posted in the MySQL database forum. There are syntax differences in the dialects of SQL for each of the platforms.

[barb.saunders.5]

Ok thank you :D