Trigger or no Trigger

I have an Date field which I would like to have populated every time a record is inserted.

Is it best to do this in a trigger or via stored proc?

Trigger:
UPDATE GOOD_SAYINGS SET GOOD_DATE =CURRENT_TIMESTAMP WHERE ID = ' How to get the lastest ID as this is a after insert trigger';

I will need to get the latest ID field to add a where clause. How would be the best method for this?

Is the trigger updating a field in the same table that is updated by the triggering sql statement?

Not yet but could if the trigger is the way to go. I thinking of populating the date field after insert. I guess the answer would be yes as the trigger is updating the field is this a good idea?

In this case you can use an "before update" or "before insert" trigger to set the new value for the column

Trigger is the way to go!

See my blog for an example.

Nice example thanks!