DERIVED FIELD autocalculation

• cincuan

  SSC Journeyman

  Points: 83

  More actions

  January 1, 2004 at 8:30 am

  #358785

  I am creating a table for a student database. I had the Dateofbirth field, I want to have anotehr DERIVED field called AGE where I can automaticall generate that field. How do i create it so that i can auto calculate the age and keep track of the age by the seconds, minutes, hours, days,

• wz700

  SSCertifiable

  Points: 7133

  More actions

  January 1, 2004 at 6:40 pm

  #488435

  A computed column can be spedified by one unit of calculation. It could be one of seconds, minutes, hours, days and years.

  You can achieve any formt by using datediff function in query without derived field in table.