Thread: keeping track of date

What would be the recommended way to keep track of the date/time a tuple
was inserted?

Should I be using triggers on insert, or is there an internal variable I
can use to avoid creating another field?

Thanks,
Marc

admin wrote:

> What would be the recommended way to keep track of the date/time a tuple
> was inserted?
>
> Should I be using triggers on insert, or is there an internal variable I
> can use to avoid creating another field?

Here's how I'm doing it:

CREATE TABLE mytable (
    ...
    creation_time  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

Cheers,
Ed Loehr