Timestamp(14) Question

[Caesar]

Hi guys,

Let's say that I have a table with the following fields:

Fields: a (doesn't matter what kind of data type)
b (doesn't matter what kind of data type)
c timestamp(14)
d timestamp(14)

Everytime a new record is created, a and b fields are filled up together with the record created time in c.

As for d, I'll like to use a script that detects the time at which the script was run and have a timestamp(14) (in other words, "select now()+ 0" query) query run and placed into a certain unique record id (assume that a is unique).

Any ideas?