Calculation of non-database columns

[prev] [thread] [next] [Date index for 2005/06/02]

Hello,

I have a table with two dates ('from' and 'to'). I inflate them (with
has_a) to a DateTime object.

Now I want to calculate the timespan between these two DateTime objects
everytime the record is read from the database. Can I use TEMP columns
for this? How? (The problem is not the calculation itself, it's the 
Class-DBI context.)

Or should I use trigger? But which one? The two DateTime objects need
already to be inflated.

Thank you very much,

good bye,
Uwe