Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


date and time stamp a changed row

lothariolothario Member Posts: 10

I am about to declare a table with 20 columns.

How do I create 4 more columns:
1. current Time
2. current Day of the month
3. current Month
4. current Year

Such that:
a. These 4 columns are not editable by the user.
b. Whenever a row is updated/inserted/replace/etc. then
these 4 columns in that row are automatically updated
by the system accordingly.

Sign In or Register to comment.