Member Avatar for 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

  • 3 Contributors
  • 4 Replies
  • 4K Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by barb.saunders.5
Member Avatar for 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.

Edited by BitBlt
Member Avatar for 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

Member Avatar for 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.

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.