Since this column "will only record the current date and time", then define / alter it (in the database) to have a default value of the "current date and time" on insert.
SQL DEFAULT Constraint[
^]
If you need something more elaborate, use a stored procedure or trigger.