Calculated fields in a database

Neil Winchurst neil at holsdev.vispa.com
Wed Jun 27 08:39:25 BST 2007


On Tue, 26 Jun 2007 10:51:57 -0500
manchicken <manchicken at notsosoft.net> wrote:

> 
> You could always just stick it into your query.  I don't know how to do this 
> in MySQL, butyou could just turn the two dates to epoch, subtract today from 
> the birthdate, and then divide it by (60*60*24*365.25) to get the years.
> 
> -- 
> ~ manchicken <><
> (A)bort, (R)etry, (I)nfluence with large hammer.
> 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
> 
Yes, of course there will be ways around it. But in my original email I
was not talking about a query, I was referring to using a normal form
to move through records. A calculated field looks like a normal field
when viewing. But, as I said, it is not picking up data from a table it
is showing the result of a calculation.

Neil Winchurst



More information about the kubuntu-users mailing list