Thread: date update check

date update check

From
"sZEJTAN"
Date:
Hullo

Is it possible to create trigger on date update? For example automatically
alter sbd's age every day;-)


Re: date update check

From
Bruno Wolff III
Date:
On Wed, May 04, 2005 at 20:57:26 +0200,
  sZEJTAN <szejtan@poczta.onet.pl> wrote:
> Hullo
>
> Is it possible to create trigger on date update? For example automatically
> alter sbd's age every day;-)

The normal solution to update things when the day changes would be to set up a
cron job to do this.

However, for ages you should be storing a birthdate and not an age.