Home > IT Answers > DataCenter > Record update.
Pierrewhy68
0 pts.
 Record update.
DataCenter
Is there an hidden Date/Time field on each record that keep track of the record creation or update? What is the best way to do so without having to create a new Date/Time field. Thank you, Roger

Software/Hardware used:
ASKED: December 9, 2004  2:01 PM
UPDATED: December 13, 2004  8:58 AM
RELATED QUESTIONS
Answer Wiki:
As far as I know there is no hiddeN timestamp in the rows of a table. For you own security it's better to have a timestamp for controlling update or insert. In my own case I have four control columns : CREATION_USER, CREATION_TIMESTAMP, MODIFICATION_USER, MODIFICATION_TIMESTAMP in all tables.
Last Wiki Answer Submitted:  December 13, 2004  8:58 am  by  Inoboa   0 pts.
All Answer Wiki Contributors:  Inoboa   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _